X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 72ACE52AE5 for ; Mon, 18 Jul 2005 01:33:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74721-08 for ; Mon, 18 Jul 2005 04:33:05 +0000 (GMT) Received: from rambo.iniquinet.com (rambo.iniquinet.com [69.39.89.10]) by svr1.postgresql.org (Postfix) with ESMTP id 3C2EA52AD4 for ; Mon, 18 Jul 2005 01:33:04 -0300 (ADT) Received: (qmail 20635 invoked by uid 1010); 18 Jul 2005 00:33:04 -0400 Received: from Robert_Creager@LogicalChaos.org by rambo.iniquinet.com by uid 1002 with qmail-scanner-1.20 (clamscan: 0.70. spamassassin: 3.0.3. Clear:RC:0(63.147.78.131):SA:0(?/?):. Processed in 1.892918 secs); 18 Jul 2005 04:33:04 -0000 Received: from unknown (HELO thunder.logicalchaos.org) (perl?test@logicalchaos.org@63.147.78.131) by rambo.iniquinet.com with AES256-SHA encrypted SMTP; 18 Jul 2005 00:33:02 -0400 Received: from logicalchaos.org (thunder.logicalchaos.org [192.168.0.250]) by thunder.logicalchaos.org (Postfix) with ESMTP id 39C97B31D3; Sun, 17 Jul 2005 22:33:00 -0600 (MDT) Date: Sun, 17 Jul 2005 22:32:59 -0600 From: Robert Creager To: "Matthew T. O'Connor" Cc: PGPerformance Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS Message-ID: <20050717223259.4eca3b8c@thunder.logicalchaos.org> In-Reply-To: <42DB2DA3.6000909@zeut.net> References: <20050717213416.59dcb52e@thunder.logicalchaos.org> <42DB2684.9020706@zeut.net> <20050717221050.7c4ac241@thunder.logicalchaos.org> <42DB2DA3.6000909@zeut.net> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed-Claws 1.0.3 (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Signature_Sun__17_Jul_2005_22_32_59_-0600_=FG.4ymlW8TtsHIL"; protocol="application/pgp-signature"; micalg=pgp-sha1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/247 X-Sequence-Number: 13488 --Signature_Sun__17_Jul_2005_22_32_59_-0600_=FG.4ymlW8TtsHIL Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable When grilled further on (Mon, 18 Jul 2005 00:18:43 -0400), "Matthew T. O'Connor" confessed: > Have you turned on the query logging to see what queries are=20 > taking so long? >=20 Yeah. In the original message is a typical query. One from 741 and the ot= her on 803. On 803, an explain analyze is done twice. Once during the problem, once when the system is idle. On 741, the query behaves the same no matter what... Cheers, Rob --=20 22:31:18 up 4 days, 2:06, 8 users, load average: 0.25, 0.18, 0.11 Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004 --Signature_Sun__17_Jul_2005_22_32_59_-0600_=FG.4ymlW8TtsHIL Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEYEARECAAYFAkLbMPsACgkQLQ/DKuwDYzkCpwCgjzwS/ibdEN9d3LAfY3gKRDfD srsAnj3K7fWvN3TADjH9FI2TCzV2ZZp9 =2ZIa -----END PGP SIGNATURE----- --Signature_Sun__17_Jul_2005_22_32_59_-0600_=FG.4ymlW8TtsHIL--