Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group