Re: AND OR combination: index not being used

От: Tom Lane
Тема: Re: AND OR combination: index not being used
Дата: ,
Msg-id: 254.1115907326@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: AND OR combination: index not being used  (David Teran)
Ответы: Re: AND OR combination: index not being used  (David Teran)
Список: pgsql-performance

David Teran <> writes:
> Any hint how
> to force postgres to use the index even with more OR parts?

More up-to-date statistics would evidently help; the thing is estimating
hundreds of rows returned and actually finding none.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Manfred Koizar
Дата:
Сообщение: Re: Sort and index
От: Sebastian Hennebrueder
Дата:
Сообщение: Optimize complex join to use where condition before join