Message-ID: <453FD351.7000408@archonet.com>
Date: Wed, 25 Oct 2006 22:12:49 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060909)
MIME-Version: 1.0
To: Mark Lonsdale <mark.lonsdale@wysdm.com>
Cc: "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org
Subject: Re: Configuration Issue ?
References: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3>
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark Lonsdale wrote:
> 
> Hi Josh
> 
> Thanks for the feedback, that is most usefull.  When you said one of the
> settings was likely killing us, was it all of the settings for
> max_fsm_relations, max_fsm_pages, and sort_mem or just the setting for
> sort_mem ?
> 
> Can you explain why the setting would be killing me :-)

The sort_mem is crucial. It's memory *per sort*, which means one query 
can use several times that amount.

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

Joshua means this too. Upgrade to 7.3.16 within the next few days, then 
test out something more recent. You should see some useful performance 
gains from 8.1.

-- 
   Richard Huxton
   Archonet Ltd