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 »
andremachado's picture
Created by andremachado 5 years 31 weeks ago
Category: High End   Tags: