_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
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

譴 蟆 讌蠍 覦朱 螳螻 り 覩遂 蟆企. (一企 觜れ洲)