PostgreSQL tuning example for 9.1 postgresql.conf

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.

Subscribe to RSS - pgfouine