Re: hash index improving v3 - Mailing list pgsql-patches

From Tom Lane
Subject Re: hash index improving v3
Date
Msg-id 22574.1220728178@sss.pgh.pa.us
Whole thread Raw
In response to Re: hash index improving v3  ("Alex Hunsaker" <badalex@gmail.com>)
Responses Re: hash index improving v3  ("Alex Hunsaker" <badalex@gmail.com>)
Re: hash index improving v3  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-patches
"Alex Hunsaker" <badalex@gmail.com> writes:
> On Fri, Sep 5, 2008 at 2:21 PM, Alex Hunsaker <badalex@gmail.com> wrote:
>> Ok now that I made it so it actually *test* collisions, with the patch
>> it always returns all rows that matched the hashed "key".

> And here is the fix, we just forget to set the recheck flag for bitmap scans.

For the convenience of anyone intending to test, here is an updated
patch against CVS HEAD that incorporates Alex's fix.

            regards, tom lane


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: hash index improving v3
Next
From: Bruce Momjian
Date:
Subject: Re: still alive?