| From: | "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> |
|---|---|
| To: | Jérôme BENOIS <benois(at)argia-engineering(dot)fr> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High CPU Load |
| Date: | 2006-09-18 15:48:53 |
| Message-ID: | 1d4e0c10609180848u153c8c20n3858a559b43a3146@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 9/18/06, Jérôme BENOIS <benois(at)argia-engineering(dot)fr> wrote:
> Tomorrow morning i plan to add 2Go RAM in order to test difference with
> my actual config.
I don't think more RAM will change anything if you don't swap at all.
You can try to set shared_buffers lower (try 32768 and 16384) but I
don't think it will change anything in 8.1.
The only thing left IMHO is that 8.1 is choosing a bad plan which
consumes a lot of CPU for at least a query.
When you analyze your logs, did you see a particularly slow query? Can
you compare query log analysis from your old server and your new one?
--
Guillaume
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-09-18 20:56:22 | Re: Large tables (was: RAID 0 not as fast as expected) |
| Previous Message | Jérôme BENOIS | 2006-09-18 14:44:05 | Re: High CPU Load |