Each tuning is almost unique. We show postgresql.conf file for 9.1 version as a starting point on Debian GNU/Linux systems.
These examples were deployed for a given major query profile, discovered using PgFouine.
Also, the hardware played critical role in the tuning choices. A powerful 16 cores Xeon, with 32 GB ECC RAM enterprise server, connected to a Fiber Channel Data Storage Server with FC disks and many GB of NVRAM.
The data storage server is a key to the performance.
It behaves (latency and IOPS wise) like a giant Enterprise SSD. Also, allows the simultaneous I/O to be so high. This kind of storage server allows a reduced random page cost too.Full story »