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
