Re: Why does query planner choose slower BitmapAnd ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why does query planner choose slower BitmapAnd ?
Дата
Msg-id 25689.1456161928@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why does query planner choose slower BitmapAnd ?  (Seamus Abshere <seamus@abshere.net>)
Список pgsql-general
Seamus Abshere <seamus@abshere.net> writes:
> On Mon, Feb 22, 2016, at 02:14 PM, Tom Lane wrote:
>> IOW, almost certainly we *don't* realize that the query will involve scanning through gigabytes of index pages.  But
btreeindexes are much simpler and easier to make that estimate for... 

> Isn't this the crux of my issue, at least?

Not unless you are using a GIST index for booleans, which I sure hope you
ain't.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why does query planner choose slower BitmapAnd ?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Why does query planner choose slower BitmapAnd ?