------=_Part_1087_10220079.1211292848345
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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
------=_Part_1087_10220079.1211292848345
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi,<br><br>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 <a
href="http://www.powerpostgresql.com/PerfList/">http://www.powerpostgresql.com/PerfList/</a>,
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.<br>
<br>I have read over the rest of the artical and adjusted some of the
other values mentioned. The values I have altered
are:<br><br>work_mem = 33554
# min
64, size in KB<br>maintenance_work_mem = 33554
# min 1024, size in KB<br>
max_fsm_pages = 100000
# min
max_fsm_relations*16, 6 bytes each<br><br>vacuum_cost_delay =
50
# 0-1000 milliseconds<br><br>wal_buffers = 64
# min 4, 8KB each<br>
commit_delay = 0
# range 0-100000, in microseconds<br>commit_siblings = 50
# range 1-1000<br><br>effective_cache_size =
33333000 # typically 8KB each<br><br>autovacuum =
on
# enable autovacuum subprocess?<br>
autovacuum_naptime = 30
# time between autovacuum runs, in
secs<br>autovacuum_vacuum_threshold = 400 # min # of
tuple updates before vacuum<br>autovacuum_analyze_threshold =
100 # min # of tuple updates before analyze<br>
autovacuum_vacuum_scale_factor = 0.4 # fraction of rel
size before vacuum<br>autovacuum_analyze_scale_factor =
0.2 # fraction of rel size before analyze<br><br>Is it
ok to have these settings with increasing the amount of shared buffers ?
<br>
<br><br>Thanks for any advice,<br><br>Andy<br><br><br>
------=_Part_1087_10220079.1211292848345--
|
