Re: Index not used with IS NULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dima Tkach <dmitry(at)openratings(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index not used with IS NULL
Date: 2003-02-17 04:46:00
Message-ID: 1785.1045457160@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dima Tkach <dmitry(at)openratings(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-17 05:42:19 Re: Index not used with IS NULL
Previous Message Dima Tkach 2003-02-17 04:16:23 Re: Index not used with IS NULL