Re: postgresql.conf suggestions?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, May 20, 2009 at 12:22 PM, Kobby Dapaah <kdapaah@xxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux