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 B57C99FA2E6 for ; Thu, 14 Sep 2006 11:21:55 -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 73798-10 for ; Thu, 14 Sep 2006 14:21:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 178CF9F9F2F for ; Thu, 14 Sep 2006 11:21:51 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 14 Sep 2006 14:21:51 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 14 Sep 2006 09:21:50 -0500 Subject: Re: High CPU Load From: Scott Marlowe To: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS Cc: Tom Lane , pgsql-performance@postgresql.org In-Reply-To: <1158243436.5226.35.camel@localhost.localdomain> References: <1158239339.5226.17.camel@localhost.localdomain> <28868.1158243217@sss.pgh.pa.us> <1158243436.5226.35.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1158243710.24726.12.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 14 Sep 2006 09:21:50 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/155 X-Sequence-Number: 20841 On Thu, 2006-09-14 at 09:17, J=C3=A9r=C3=B4me BENOIS wrote: > Hi Tom, >=20 > Le jeudi 14 septembre 2006 =C3=A0 10:13 -0400, Tom Lane a =C3=A9crit : > > =3D?ISO-8859-1?Q?J=3DE9r=3DF4me?=3D BENOIS writes: > > > I migrated Postgres server from 7.4.6 to 8.1.4, But my server is > > > completely full, by moment load average > 40 > >=20 > > Did you remember to ANALYZE the whole database after reloading it? > > pg_dump/reload won't by itself regenerate statistics. > >=20 > > regards, tom lane > I tested, dump + restore + vaccumdb --analyze on all databases but no cha= nge ... OK, set your db to log queries that take more than a few seconds to run. Execute those queries by hand with an explain analyze in front and post the output here.