| 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 |
| 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 |
| 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 |