Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU Load - Mailing list pgsql-performance

From Tom Lane
Subject Re: High CPU Load
Date
Msg-id 28868.1158243217@sss.pgh.pa.us
Whole thread Raw
In response to High CPU Load  (Jérôme BENOIS <benois@argia-engineering.fr>)
Responses Re: High CPU Load
List pgsql-performance
Tree view 
=?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@argia-engineering.fr> writes:
>    I migrated Postgres server from 7.4.6 to 8.1.4, But my server is
> completely full, by moment load average > 40

Did you remember to ANALYZE the whole database after reloading it?
pg_dump/reload won't by itself regenerate statistics.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jérôme BENOIS
Date:
Subject: Re: High CPU Load
Next
From: Jérôme BENOIS
Date:
Subject: Re: High CPU Load