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

Re: postgresql.conf suggestions?

From: Greg Smith <gsmith(at)gregsmith(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 05:47:52
Message-ID: alpine.GSO.2.01.0905201353120.3025@westnet.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 20 May 2009, Kobby Dapaah wrote:

> shared_buffers = 2048MB
> effective_cache_size = 5400MB

You should consider seriously increasing effective_cache_size.  You might 
also double or quadruple shared_buffers from 2GB, but going much higher 
may not buy you much--most people seem to find diminishing returns 
increasing that beyond the 10GB range.

> bgwriter_delay = 10ms
> bgwriter_lru_maxpages = 0

I found that bg_writer_delay doesn't really work so well when set to this 
small.  It doesn't actually matter right now though, because you're 
turning the background writer off by setting brwriter_lru_maxpages=0. 
Just wanted to point this out because if you increase that later it may 
pop up as a concern, small values for the delay make it more likely you'll 
need to increase the multiplier to a higher value for background writing 
to work well.

Robert's message already mentions the other things you should consider, 
particularly work_mem.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-performance by date

Next:From: Daniel FerreiraDate: 2009-05-21 11:42:46
Subject: query planner uses sequencial scan instead of index scan
Previous:From: Robert HaasDate: 2009-05-21 03:09:52
Subject: Re: postgresql.conf suggestions?

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