Re: 8.x index insert performance - Mailing list pgsql-performance

From Kelly Burkhart
Subject Re: 8.x index insert performance
Date
Msg-id 1130792391.7026.55.camel@krb06.tradebot.com
Whole thread Raw
In response to Re: 8.x index insert performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.x index insert performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Mon, 2005-10-31 at 15:30 -0500, Tom Lane wrote:
> mark@mark.mielke.cc writes:
> > I've been trying to figure out whether null values are indexed or not from
> > the documentation. I was under the impression, that null values are not
> > stored in the index.
>
> You're mistaken, at least with regard to btree indexes.

Ha!  So I'm creating an index 98% full of nulls!  Looks like this is
easily fixed with partial indexes.

-K

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.x index insert performance
Next
From: "Merlin Moncure"
Date:
Subject: Re: 8.x index insert performance