Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 7885B1337C6F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  6 Apr 2011 05:35:29 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 89539-01-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  6 Apr 2011 08:35:20 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp1.linux-foundation.org (smtp1.linux-foundation.org
	[140.211.169.13])
	by mail.postgresql.org (Postfix) with ESMTP id E17AF1337C1F
	for <pgsql-performance@postgresql.org>;
	Wed,  6 Apr 2011 05:33:43 -0300 (ADT)
Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com
	[209.85.216.181]) (authenticated bits=0)
	by smtp1.linux-foundation.org (8.14.2/8.13.5/Debian-3ubuntu1.1) with
	ESMTP id p368XgVf008367
	(version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL)
	for <pgsql-performance@postgresql.org>; Wed, 6 Apr 2011 01:33:43 -0700
Received: by qyg14 with SMTP id 14so865271qyg.19
	for <pgsql-performance@postgresql.org>;
	Wed, 06 Apr 2011 01:33:42 -0700 (PDT)
Received: by 10.229.62.7 with SMTP id v7mr490623qch.281.1302078822120; Wed, 06
	Apr 2011 01:33:42 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.229.10.17 with HTTP; Wed, 6 Apr 2011 01:33:12 -0700 (PDT)
In-Reply-To: <20110405230251.GD26726@aart.is.rice.edu>
References: <BANLkTimFZjYve4GDOXQJ6VjRO1pOQEwp4w@mail.gmail.com>
	<20110405230251.GD26726@aart.is.rice.edu>
From: Thom Brown <thom@linux.com>
Date: Wed, 6 Apr 2011 09:33:12 +0100
Message-ID: <BANLkTim7Uht33ZGgmQnvGCsqGRmtV8GGGg@mail.gmail.com>
Subject: Re: Partial index slower than regular index
To: Kenneth Marshall <ktm@rice.edu>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
X-MIMEDefang-Filter: lf$Revision: 1.188 $
X-Scanned-By: MIMEDefang 2.63 on 140.211.169.13
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201104/41
X-Sequence-Number: 43103

On 6 April 2011 00:02, Kenneth Marshall <ktm@rice.edu> wrote:
> The stats seem off. Are you certain that an analyze has run?
>
> Cheers,
> Ken
>

Yes, an ANALYZE was definitely run against the table.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company