Hi,
I am currently trying to tweak Postgresql 8.1, to improve the overall performance of the database. I have read over the following page/artical
http://www.powerpostgresql.com/PerfList/, however at the moment (not for much longer hopefully) my hands aree tied when it comes to altering the kernel parameters, and thus allocating more shared buffers.
I have read over the rest of the artical and adjusted some of the other values mentioned. The values I have altered are:
work_mem = 33554 # min 64, size in KB
maintenance_work_mem = 33554 # min 1024, size in KB
max_fsm_pages = 100000 # min max_fsm_relations*16, 6 bytes each
vacuum_cost_delay = 50 # 0-1000 milliseconds
wal_buffers = 64 # min 4, 8KB each
commit_delay = 0 # range 0-100000, in microseconds
commit_siblings = 50 # range 1-1000
effective_cache_size = 33333000 # typically 8KB each
autovacuum = on # enable autovacuum subprocess?
autovacuum_naptime = 30 # time between autovacuum runs, in secs
autovacuum_vacuum_threshold = 400 # min # of tuple updates before vacuum
autovacuum_analyze_threshold = 100 # min # of tuple updates before analyze
autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before vacuum
autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before analyze
Is it ok to have these settings with increasing the amount of shared buffers ?
Thanks for any advice,
Andy