Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug? 8.0 does not use partial index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug? 8.0 does not use partial index
Date
Msg-id 13718.1105652038@sss.pgh.pa.us
Whole thread Raw
In response to Bug? 8.0 does not use partial index  (Palle Girgensohn <girgen@pingpong.net>)
Responses Re: Bug? 8.0 does not use partial index
List pgsql-hackers
Tree view 
Palle Girgensohn <girgen@pingpong.net> writes:
> On 7.4.5, it uses the index, but on 8.0rc5, it does not:

Have you ANALYZEd the 8.0 table lately?  Those rowcount estimates look
mighty far off.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: sparse (static analyzer) report
Next
From: Tom Lane
Date:
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)