Re: Partial index slower than regular index

From: Thom Brown <thom(at)linux(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Partial index slower than regular index
Date: 2011-04-06 08:33:12
Message-ID: BANLkTim7Uht33ZGgmQnvGCsqGRmtV8GGGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6 April 2011 00:02, Kenneth Marshall <ktm(at)rice(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2011-04-06 11:41:23 Re: help speeding up a query in postgres 8.4.5
Previous Message Thom Brown 2011-04-06 08:15:25 Re: Partial index slower than regular index