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

From: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Way to avoid expensive Recheck Cond in index lookup?
Date: 2007-12-19 00:47:00
Message-ID: 51517.192.168.1.108.1198025220.squirrel@msqr.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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@

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-12-19 01:45:20 Re: Way to avoid expensive Recheck Cond in index lookup?
Previous Message Tom Lane 2007-12-18 22:24:06 Re: Way to avoid expensive Recheck Cond in index lookup?