Drawbacks of create index where is not null ? - Mailing list pgsql-performance

From Franck Routier
Subject Drawbacks of create index where is not null ?
Date
Msg-id 5075AB0F.5030005@axege.com
Whole thread Raw
Responses Re: Drawbacks of create index where is not null ?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-performance
Hi,

I have pretty large tables, with columns that might never receive any
data, or always receive data, based on the customer needs.
The index on these columns are really big, even if the column is never
used, so I tend to add a "where col is not null" clause on those indexes.

What are the drawbacks of defining my index with a "where col is not
null" clause ?

Franck


Attachment

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: shared_buffers/effective_cache_size on 96GB server
Next
From: Craig James
Date:
Subject: Re: Hyperthreading (was: Two identical systems, radically different performance)