Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A9F779F9FE1 for ; Thu, 7 Dec 2006 02:01:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 93247-08 for ; Thu, 7 Dec 2006 02:01:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id DBC9B9F9C35 for ; Thu, 7 Dec 2006 02:01:39 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id EE24956435; Thu, 7 Dec 2006 06:01:37 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Thu, 7 Dec 2006 00:01:33 -0600 Date: Thu, 7 Dec 2006 00:01:33 -0600 From: "Jim C. Nasby" To: Arjen van der Meijden Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: 8.2rc1 (much) slower than 8.2dev? Message-ID: <20061207060133.GU44124@nasby.net> References: <4573D1F7.600@tweakers.net> <16696.1165244024@sss.pgh.pa.us> <45744FAA.20603@tweakers.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45744FAA.20603@tweakers.net> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061207:acmmailing@tweakers.net::2Tk8G7RmevTZxlGM:00000000000000 000000000000000000000000921z X-Hashcash: 1:20:061207:tgl@sss.pgh.pa.us::KnZwGrK++rWx3kjh:00000000000000000000 0000000000000000000000009NFl X-Hashcash: 1:20:061207:pgsql-performance@postgresql.org::5spX0XaAnKPgBAlS:00000 0000000000000000000000007X0R X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/162 X-Sequence-Number: 22218 On Mon, Dec 04, 2006 at 05:41:14PM +0100, Arjen van der Meijden wrote: > Since I'd rather not send the entire list of queries to the entire > world, is it OK to send both explain analyze-files to you off list? Can you post them on the web somewhere so everyone can look at them? Also, are you looking at EXPLAIN or EXPLAIN ANALYZE? -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)