Re: High CPU Load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-14 14:13:37
Message-ID: 28868.1158243217@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois(at)argia-engineering(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jérôme BENOIS 2006-09-14 14:17:15 Re: High CPU Load
Previous Message Jérôme BENOIS 2006-09-14 14:00:13 Re: High CPU Load