Drawbacks of create index where is not null ?

Поиск
Список
Период
Сортировка
От Franck Routier
Тема Drawbacks of create index where is not null ?
Дата
Msg-id 5075AB0F.5030005@axege.com
обсуждение исходный текст
Ответы Re: Drawbacks of create index where is not null ?  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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


Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: shared_buffers/effective_cache_size on 96GB server
Следующее
От: Craig James
Дата:
Сообщение: Re: Hyperthreading (was: Two identical systems, radically different performance)