Re: Way to avoid expensive Recheck Cond in index lookup? - Mailing list pgsql-general

From Matt Magoffin
Subject Re: Way to avoid expensive Recheck Cond in index lookup?
Date
Msg-id 51517.192.168.1.108.1198025220.squirrel@msqr.us
Whole thread Raw
In response to Re: Way to avoid expensive Recheck Cond in index lookup?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Way to avoid expensive Recheck Cond in index lookup?
Next
From: Gregory Stark
Date:
Subject: Re: Way to avoid expensive Recheck Cond in index lookup?