Re: Way to avoid expensive Recheck Cond in index lookup?

Поиск
Список
Период
Сортировка
От Matt Magoffin
Тема Re: Way to avoid expensive Recheck Cond in index lookup?
Дата
Msg-id 51517.192.168.1.108.1198025220.squirrel@msqr.us
обсуждение исходный текст
Ответ на Re: Way to avoid expensive Recheck Cond in index lookup?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>> The problem for me is, the Recheck Cond is then on the xpath() function
>> used by the function-based index. My understanding is that then the
>> database must actually call the xpath() function again on all matches
>> from
>> the index lookup.
>
> This is mistaken.  It only happens if there are so many hits that the
> bitmap becomes lossy (which you can control to some extent anyway by
> adjusting work_mem).

Ah, great. Thanks for clarifying.

-- m@

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Way to avoid expensive Recheck Cond in index lookup?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Way to avoid expensive Recheck Cond in index lookup?