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 107129FA103 for ; Thu, 14 Sep 2006 10:27:49 -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 21738-09 for ; Thu, 14 Sep 2006 10:27:34 -0300 (ADT) X-Greylist: delayed 00:18:37.950763 by SQLgrey- Received: from smtp19.orange.fr (smtp19.orange.fr [80.12.242.1]) by postgresql.org (Postfix) with ESMTP id 93A219FA0C4 for ; Thu, 14 Sep 2006 10:27:41 -0300 (ADT) Received: from smtp-msa-out19.orange.fr (mwinf1909 [172.22.129.37]) by mwinf1905.orange.fr (SMTP Server) with ESMTP id 557A85C052D9 for ; Thu, 14 Sep 2006 15:09:05 +0200 (CEST) Received: from [192.168.1.10] (LSt-Amand-152-32-6-178.w82-127.abo.wanadoo.fr [82.127.21.178]) by mwinf1909.orange.fr (SMTP Server) with ESMTP id BC76E1C00041 for ; Thu, 14 Sep 2006 15:09:00 +0200 (CEST) X-ME-UUID: 20060914130900772.BC76E1C00041@mwinf1909.orange.fr Subject: High CPU Load From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS To: pgsql-performance@postgresql.org Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-rG2MYnCpNZ45CNY2cgm8" Date: Thu, 14 Sep 2006 15:08:59 +0200 Message-Id: <1158239339.5226.17.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/148 X-Sequence-Number: 20834 --=-rG2MYnCpNZ45CNY2cgm8 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi All, I migrated Postgres server from 7.4.6 to 8.1.4, But my server is completely full, by moment load average > 40 All queries analyzed by EXPLAIN, all indexes are used .. IO is good ... My configuration is correct ? - default configuration and se + somes updates :=20 max_connections =3D 512 superuser_reserved_connections =3D 2 shared_buffers =3D 65536 work_mem =3D 65536 effective_cache_size =3D 131072 log_destination =3D 'syslog' redirect_stderr =3D off log_directory =3D '/var/log/pgsql' log_min_duration_statement =3D 100 silent_mode =3D on log_statement =3D 'none' default_with_oids =3D on My Server is Dual Xeon 3.06GHz with 2 Go RAM and good SCSI disks. Best Regards, J=C3=A9r=C3=B4me BENOIS. --=-rG2MYnCpNZ45CNY2cgm8 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) iD8DBQBFCVRqCDKlmlhpwnERApV+AJ4xcqtltA4bQsh0LftPgTfkB/I6rwCeL2CR YQNZvSk2BRCVrcxnXl6WBAU= =77Tf -----END PGP SIGNATURE----- --=-rG2MYnCpNZ45CNY2cgm8--