Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: hash-v5.patch.gz
Description: application/octet-stream (6.5 KB)

In response to

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group