Message-ID: <453FCE6A.2000700@commandprompt.com>
Date: Wed, 25 Oct 2006 13:51:54 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.7 (X11/20060918)
MIME-Version: 1.0
To: Mark Lonsdale <mark.lonsdale@wysdm.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Configuration Issue ?
References: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A84@mail3>
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A84@mail3>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Mark Lonsdale wrote:
>  
> 
> Hi 
> 
>  
> 
> Please help.  I have got a postgres 7.3.4 database running on RedHat ES
> 3, with 8GB of physical memory in it.   The machine is shared with my
> application which is pretty intensive in doing selects and updates
> against the database, but there are usually no more than 10 connections
> to the database at any time.
> 
> 
> shared_buffers = 393216         # min max_connections*2 or 16, 8KB each

The above is likely hurting you more than helping you with 7.3.

> 
> max_fsm_relations = 10000       # min 10, fsm is free space map, ~40
> bytes
> 
> max_fsm_pages = 160001          # min 1000, fsm is free space map, ~6
> 
> bytes
> 
> sort_mem = 409600               # min 64, size in KB

The above will likely kill you :). Try 4096 or 8192, maybe 16384
depending on workload.

> 
> vacuum_mem = 81920              # min 1024, size in KB

This is fine.

> 
> Also if you have any recommendations regarding effective_cache_size Id
> be interested as reading around this sounds important as well

About 20-25% of available ram for 7.3.


The long and short is you need to upgrade to at least 7.4, preferrably 8.1.

Joshua D. Drake


> 
>  
> 
> Thanks
> 
>  
> 
> Mark 
> 
>  
> 
> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate