> On Mon, Oct 31, 2005 at 12:32:03PM -0500, Merlin Moncure wrote:
> > if that index is causing the problem, you may want to consider
> > up partial index to exclude null values.
> Hey all.
> Pardon my ignorance. :-)
> I've been trying to figure out whether null values are indexed or not
> the documentation. I was under the impression, that null values are
> stored in the index. Occassionally, though, I then see a suggestion
> as the above, that seems to indicate to me that null values *are*
> in the index, allowing for the 'exclude null values' to have effect?
> Which is it? :-)
I think I'm the ignorant one...do explain on any lookup on an indexed
field where the field value is null and you get a seqscan.
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-10-31 20:30:29|
|Subject: Re: 8.x index insert performance |
|Previous:||From: mark||Date: 2005-10-31 19:35:47|
|Subject: Re: 8.x index insert performance|