Re: Configuration Issue ?

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