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

Re: Configuration Issue ?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Mark Lonsdale <mark(dot)lonsdale(at)wysdm(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration Issue ?
Date: 2006-10-25 21:12:49
Message-ID: 453FD351.7000408@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2006-10-25 21:16:55
Subject: Re: Configuration Issue ?
Previous:From: Mark LonsdaleDate: 2006-10-25 20:57:09
Subject: Re: Configuration Issue ?

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