PostgreSQL Configuration Changes with pgtune

This is an example run of the pgtune script, which examines a system's hardware and proposes changes to PostgreSQL configuration, to better utilize the capabilities of the hardware for the benefit of the database.

The following configuration differences are from an example of a VM running with 2x Intel Quad @2.33GHz CPUs and 2GB of RAM. The commands run to create the new configuration file with pgtune were:

pgtune -i /var/lib/pgsql/9.2/data/postgresql.conf -o /var/lib/pgsql/9.2/data/postgresql2.conf
mv postgresql.conf postgresql-factory-default.conf
mv postgresql2.conf postgresql.conf
chown postgres:postgres postgresql.conf
service postgresql restart


< max_connections = 100
> max_connections = 80
< #default_statistics_target = 100  
> default_statistics_target = 50 
< #constraint_exclusion = partition
> constraint_exclusion = on 
< #effective_cache_size = 128MB
> effective_cache_size = 1408MB 
< #wal_buffers = -1
> wal_buffers = 8MB

Posted on