_대문 | 방명록 | 최근글 | 홈피소개 | 주인놈
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

댓글 남기기..
이름: : 오른쪽의 새로고침을 클릭해 주세요. 새로고침
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

진정한 우정은 느리게 자라나는 나무와 같다. (조지워싱턴)