X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8EDECD1B4F0 for ; Wed, 24 Sep 2003 17:36:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 78652-10 for ; Wed, 24 Sep 2003 14:36:46 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id A7553D1B546 for ; Wed, 24 Sep 2003 14:36:44 -0300 (ADT) Received: (qmail 24144 invoked from network); 24 Sep 2003 17:36:29 -0000 Received: from host213-123-217-162.in-addr.btopenworld.com (HELO solent) (213.123.217.162) by wight.ymogen.net with SMTP; 24 Sep 2003 17:36:29 -0000 From: "Matt Clark" To: , Subject: Re: Index problem Date: Wed, 24 Sep 2003 18:35:34 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/310 X-Sequence-Number: 3676 > What causes this behaviour? is there any workaround? Suggestions? > How many rows are there in the table, and can you post the 'explain analyze' for both queries after doing a 'vacuum verbose analyze [tablename]'? Cheers Matt