Server Configuration

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

Responses

Browse pgsql-general by date

  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