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

Re: postgresql.conf suggestions?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kobby Dapaah <kdapaah(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql.conf suggestions?
Date: 2009-05-21 03:09:52
Message-ID: 603c8f070905202009p3a487b39l3a5533dd29080250@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, May 20, 2009 at 12:22 PM, Kobby Dapaah <kdapaah(at)gmail(dot)com> wrote:
> I just upgraded from a
>
> 2xIntel Xeon-Harpertown 5450-Quadcore,16 GB,Redhat EL 5.1-64
> To
> 2xIntel Xeon-Nehalem 5570-Quadcore,36GB,Redhat EL 5.3-64
>
> Any advice on how I'll get the best of this server?
>
> This is what I currently have:
> max_connections = 100
> shared_buffers = 2048MB
> maintenance_work_mem = 128MB
> max_fsm_pages = 1000000
> bgwriter_delay = 10ms
> bgwriter_lru_maxpages = 0
> wal_sync_method = open_sync
> wal_buffers = 2MB
> checkpoint_segments = 64
> checkpoint_warning = 270s
> archive_mode = on
> effective_cache_size = 5400MB
> default_statistics_target = 500
> logging_collector = on
> log_rotation_size = 100MB
> log_min_duration_statement = 1000
> log_connections = off
> log_disconnections = off
> log_duration = off
> log_line_prefix = '%t'
> track_counts = on
> autovacuum = on
> statement_timeout = 5min

What are you doing with it?  You probably want to increase work_mem,
and very likely you want to decrease random_page_cost and
seq_page_cost.  I think there may be some more bgwriter settings that
you want to fiddle as well but that's not my area of expertise.

...Robert

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2009-05-21 05:47:52
Subject: Re: postgresql.conf suggestions?
Previous:From: Richard YenDate: 2009-05-21 00:07:09
Subject: PQisBusy behaving strangely

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