Re: Index not used with IS NULL - Mailing list pgsql-general

From Tom Lane
Subject Re: Index not used with IS NULL
Date
Msg-id 1785.1045457160@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index not used with IS NULL  (Dima Tkach <dmitry@openratings.com>)
List pgsql-general
Dima Tkach <dmitry@openratings.com> writes:
> But, one problem was that in 7.2 partial indexes do not really work
> (more precisely, do not get used)  if your query has more than one table
> (Tom has given me a patch to fix that a while back, but I never got to
> installing it) :-(

That patch is in 7.2.2 and later.  If you're still running 7.2 or 7.2.1
I have *zero* sympathy for any problems you may have.  Update before
you get bit by one of the data-loss bugs we've fixed.

            regards, tom lane

pgsql-general by date:

Previous
From: Dima Tkach
Date:
Subject: Re: Index not used with IS NULL
Next
From: Tom Lane
Date:
Subject: Re: Index not used with IS NULL