Postgres Pro
Downloads
Home   >   mailing lists

Re: Partial index slower than regular index - Mailing list pgsql-performance

From Thom Brown
Subject Re: Partial index slower than regular index
Date
Msg-id BANLkTim7Uht33ZGgmQnvGCsqGRmtV8GGGg@mail.gmail.com
Whole thread Raw
In response to Re: Partial index slower than regular index  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Thom Brown
Date:
Subject: Re: Partial index slower than regular index
Next
From: Ákos Gábriel
Date:
Subject: Re: Postgres Performance Tuning