#title Pgtune Example

postgresql.conf
{{{
Windows/DW/32G RAM
-----------------------------------------------------
max_connections = 20
shared_buffers = 8GB
effective_cache_size = 24GB
work_mem = 209715kB
maintenance_work_mem = 2GB
checkpoint_segments = 128
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 500


Windows/DW/16G RAM
-----------------------------------------------------
max_connections = 20
shared_buffers = 512MB
effective_cache_size = 12GB
work_mem = 135441kB
maintenance_work_mem = 2GB
checkpoint_segments = 128
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 500


Linux/DW/32G RAM
-----------------------------------------------------
max_connections = 20
shared_buffers = 8GB
effective_cache_size = 24GB
work_mem = 209715kB
maintenance_work_mem = 2GB
checkpoint_segments = 128
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 500


Linux/DW/16G RAM
-----------------------------------------------------
max_connections = 20
shared_buffers = 4GB
effective_cache_size = 12GB
work_mem = 104857kB
maintenance_work_mem = 2GB
checkpoint_segments = 128
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 500
}}}