| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-10-25 21:16:55 | Re: Configuration Issue ? |
| Previous Message | Mark Lonsdale | 2006-10-25 20:57:09 | Re: Configuration Issue ? |