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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group