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

Re: Index on a NULL-value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Tobias Brox <tobias(at)nordicbet(dot)com>,Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Index on a NULL-value
Date: 2005-05-31 05:12:46
Message-ID: 8324.1117516366@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Greg Stark <gsstark(at)mit(dot)edu> writes:
> then it would be a candidate because the ORDER BY or the other > 0 make the
> index look relevant. But I don't think (again I'm not 100% sure) that the
> partial index WHERE clause is considered in picking which indexes to consider.

Nope, the partial index will be considered simply on the strength of its
predicate matching the WHERE clause.

Of course, if you can get some additional mileage by having the index
contents be useful, that's great --- but it's not necessary.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Tobias BroxDate: 2005-05-31 05:59:32
Subject: Re: Index on a NULL-value
Previous:From: Greg StarkDate: 2005-05-31 04:21:25
Subject: Re: Index on a NULL-value

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