X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 2AE8E9FA2E6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 14 Sep 2006 11:13:44 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 73627-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 14 Sep 2006 14:13:41 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id D2BF19FA0FC
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Sep 2006 11:13:40 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8EEDcll028869;
	Thu, 14 Sep 2006 10:13:38 -0400 (EDT)
To: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@argia-engineering.fr>
cc: pgsql-performance@postgresql.org
Subject: Re: High CPU Load 
In-reply-to: <1158239339.5226.17.camel@localhost.localdomain> 
References: <1158239339.5226.17.camel@localhost.localdomain>
Comments: In-reply-to =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS
	<benois@argia-engineering.fr>
	message dated "Thu, 14 Sep 2006 15:08:59 +0200"
Date: Thu, 14 Sep 2006 10:13:37 -0400
Message-ID: <28868.1158243217@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200609/151
X-Sequence-Number: 20837

=?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