Re: Performance tuning on RedHat Enterprise Linux 3

On Mon, Dec 06, 2004 at 09:08:02AM -0500, David Esposito wrote:
> shared_buffers = 131072 (roughly 1GB)
> max_fsm_relations = 10000
> max_fsm_pages = 10000000
> sort_mem = 4096
> vacuum_mem = 262144
> Roughly 25 - 30 connections open (mostly idle) at any given time
> (connection pools)

I'd suggest reducing shared_buffers to maybe a few thousand, there's
really no point reserving so much memory that way, it just a waste.

Secondly, up your sort_mem a bit to reflact how big your sorts are
likely to be.

How's your effective_cache_size?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.