X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 878863A3E5E for ; Thu, 28 Oct 2004 16:06:32 +0100 (BST) 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 22486-05 for ; Thu, 28 Oct 2004 15:06:31 +0000 (GMT) Received: from stan.ringways.co.uk (hub.ringways.co.uk [213.38.87.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1A3763A3C21 for ; Thu, 28 Oct 2004 16:06:29 +0100 (BST) Received: from gary.ringways.co.uk ([10.1.1.2]) by stan.ringways.co.uk with esmtp (Exim 3.22 #1) id 1CNBvy-00047F-00; Thu, 28 Oct 2004 16:11:26 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Gary Stainburn Organization: Ringways Garages Ltd To: Tom Lane Subject: Re: curious delay on view/where Date: Thu, 28 Oct 2004 16:01:59 +0100 User-Agent: KMail/1.4.3 Cc: pgsql-sql@postgresql.org References: <200410281116.44972.gary.stainburn@ringways.co.uk> <1758.1098973507@sss.pgh.pa.us> In-Reply-To: <1758.1098973507@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200410281601.59009.gary.stainburn@ringways.co.uk> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/205 X-Sequence-Number: 19308 On Thursday 28 October 2004 3:25 pm, Tom Lane wrote: > Gary Stainburn writes: > > Anyone got any ideas of the cause, or thoughts on how I can trace > > the problem? > > EXPLAIN ANALYZE results for the fast and slow cases would be > interesting. Also, have you ANALYZEd the underlying tables lately? > And what PG version is this? > > regards, tom lane Hi Tom. I've the analyze but don't understand what it's telling me. I've made it available at http://www.stainburn.com/analyze.txt Gary -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000