Re: hash index improving v3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alex Hunsaker" <badalex(at)gmail(dot)com>
Cc: "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>, "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>, pgsql-patches(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: Re: hash index improving v3
Date: 2008-09-06 19:09:38
Message-ID: 22574.1220728178@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Alex Hunsaker" <badalex(at)gmail(dot)com> writes:
> On Fri, Sep 5, 2008 at 2:21 PM, Alex Hunsaker <badalex(at)gmail(dot)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 Content-Type Size
hash-v5.patch.gz application/octet-stream 6.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2008-09-06 19:40:55 Re: [PATCH] "\ef <function>" in psql
Previous Message Tom Lane 2008-09-06 18:58:25 Re: [PATCH] "\ef <function>" in psql

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2008-09-06 19:55:21 Re: still alive?
Previous Message Tom Lane 2008-09-06 18:14:26 Re: hash index improving v3