From: | "Andy Dale" <andy(dot)dale(at)gmail(dot)com> |
---|---|
To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Server Configuration |
Date: | 2008-05-20 14:14:08 |
Message-ID: | faa313130805200714l1040dd98x4b0227883e2e5c1d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2008-05-20 14:14:19 | Re: ranked subqueries vs distinct question |
Previous Message | paragasu | 2008-05-20 13:58:31 | Re: i am looking for postgresql hosting server |