Tag: tuning

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: tuning. You can go back to all blog posts or take a look into our other categories & tags.

Adjusting maintenance_work_mem

by Hans-Jürgen Schönig | 02.2014
After testing shared_buffers recently, I decided to do a little more testing on our new office desktop PC (8 core […]

PostgreSQL 9.3 - Shared Buffers Performance (1)

by Hans-Jürgen Schönig | 02.2014
A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week […]

PostgreSQL: Linux kernel I/O tuning

by Hans-Jürgen Schönig | 10.2013
When you are installing a database server, PostgreSQL is not the only thing which can be tuned. The operating system […]

PostgreSQL block sizes: Getting started ...

by Hans-Jürgen Schönig | 06.2013
I have been wondering a while about the optimal block size in PostgreSQL. Usually the default value of 8kb has […]

Functions: The most widely ignored performance tweak

by Hans-Jürgen Schönig | 05.2013
It happens quite frequently that people complain about stored procedure performance in PostgreSQL. In many cases the reason for bad […]

Better PostgreSQL performance on SSDs

by Hans-Jürgen Schönig | 01.2013
The optimizer uses several parameters to optimize queries. Those parameters have been constant for many years in the past. This […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram