From: Richard Huxton <dev@archonet.com>
To: Mark Lonsdale <mark.lonsdale@wysdm.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuration Issue ?
Date: Wed, 25 Oct 2006 22:12:49 +0100
Message-ID: <453FD351.7000408@archonet.com> (raw)
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3>
References: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, mark.lonsdale@wysdm.com, jd@commandprompt.com
Subject: Re: Configuration Issue ?
In-Reply-To: <453FD351.7000408@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox