Re: checking for a NULL date in a partitioned table kills performance

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: checking for a NULL date in a partitioned table kills performance
Дата
Msg-id CAKFQuwZKTiS5b_Loe21p9rFBzR5XriHODPeocP40QAECTHEMkA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: checking for a NULL date in a partitioned table kills performance  (Sbob <sbob@quadratum-braccas.com>)
Список pgsql-admin
Дерево обсуждения
On Thu, Aug 22, 2024 at 4:32 PM Sbob <sbob@quadratum-braccas.com> wrote:

29 million of the 32 million rows in the table have NULL for contract_date


Your expectation that this query should use an index is flawed.  Indexes are for highly selective queries.  Finding nulls on that table is not selective.

David J.

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