> 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....
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...
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-01-13 22:05:00|
|Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster) |
|Previous:||From: Tom Lane||Date: 2005-01-13 22:03:41|
|Subject: Re: Bug? 8.0 does not use partial index |