Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Karsten HilbertDate: 2008-05-20 14:14:19
Subject: Re: ranked subqueries vs distinct question
Previous:From: paragasuDate: 2008-05-20 13:58:31
Subject: Re: i am looking for postgresql hosting server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group