Re: Bitmap scan when it is not needed

От: Tom Lane
Тема: Re: Bitmap scan when it is not needed
Дата: ,
Msg-id: 28244.1125269347@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Bitmap scan when it is not needed  ("Ilia Kantor")
Список: pgsql-performance

"Ilia Kantor" <> writes:
> Maybe a quickfix is possible for cases when 0 records is found to stop
> reading other AND elements..

Not sure how useful this will be in practice (since the planner tends
not to bother ANDing unselective indexes at all), but it's easy enough
to do ... so I did it.

            regards, tom lane


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

От: Tom Lane
Дата:
Сообщение: Re: Bitmap scan when it is not needed
От: Carlos Henrique Reimer
Дата:
Сообщение: shared buffers