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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group