_대문 | 방명록 | 최근글 | 홈피소개 | 주인놈 |
FrontPage › PgtuneExample
|
|
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
|
진정한 우정은 느리게 자라나는 나무와 같다. (조지워싱턴) |