X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D76E69F9F2F for ; Thu, 14 Sep 2006 11:17:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45379-02 for ; Thu, 14 Sep 2006 11:17:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-msa-out19.orange.fr (smtp19.orange.fr [80.12.242.17]) by postgresql.org (Postfix) with ESMTP id BE68B9FA2E6 for ; Thu, 14 Sep 2006 11:17:19 -0300 (ADT) Received: from [192.168.1.10] (LSt-Amand-152-32-6-178.w82-127.abo.wanadoo.fr [82.127.21.178]) by mwinf1911.orange.fr (SMTP Server) with ESMTP id EA02C1C00119; Thu, 14 Sep 2006 16:17:17 +0200 (CEST) X-ME-UUID: 20060914141717958.EA02C1C00119@mwinf1911.orange.fr Subject: Re: High CPU Load From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <28868.1158243217@sss.pgh.pa.us> References: <1158239339.5226.17.camel@localhost.localdomain> <28868.1158243217@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-akV01hoyUuxIOQUZu1so" Date: Thu, 14 Sep 2006 16:17:15 +0200 Message-Id: <1158243436.5226.35.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/152 X-Sequence-Number: 20838 --=-akV01hoyUuxIOQUZu1so Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Tom, 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 chang= e ... Cheers, --=20 J=C3=A9r=C3=B4me, python -c "print '@'.join(['.'.join([w[::-1] for w in p.split('.')]) for p in 'sioneb@gnireenigne-aigra.rf'.split('@')])" --=-akV01hoyUuxIOQUZu1so Content-Type: application/pgp-signature; name=signature.asc Content-Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?= -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) iD8DBQBFCWRrCDKlmlhpwnERAoBjAJ4xA9rhPKPfH9F4WPw9MG+VpBxG1ACfUBHz Eik6eFhtn3Avl35yKO5bWzU= =sX6Y -----END PGP SIGNATURE----- --=-akV01hoyUuxIOQUZu1so--