Re: Bug? 8.0 does not use partial index

From: John Hansen <john(at)geeknet(dot)com(dot)au>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug? 8.0 does not use partial index
Date: 2005-01-13 22:04:25
Message-ID: 1105653866.24775.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Thanks, but the behaviour seems identical. :(

odd tho, that I was never able to get null values indexed (index was
never used) unless I used this approach....

hmmmm
on the other hand,.... just realised youre not actually indexing null
values,... here, is null is the qualifier for the partial index....

as tom suggested, try vacuum analyze on that table...

... JOhn

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-01-13 22:05:00 Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Previous Message Tom Lane 2005-01-13 22:03:41 Re: Bug? 8.0 does not use partial index