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:
2008-08-18 01:46:06 from "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>
2008-08-19 09:28:38 from "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>
2008-09-04 02:06:42 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-04 04:10:06 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2008-09-04 05:35:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-04 13:03:45 from "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>
2008-09-04 16:57:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-05 13:05:38 from "Xiao Meng" <mx(dot)cogito(at)gmail(dot)com>
2008-09-04 12:54:37 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-04 20:06:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-04 20:28:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-04 23:11:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-05 00:42:53 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 01:13:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-05 01:45:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-05 01:54:51 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 02:17:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-05 03:48:41 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 06:32:16 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 06:43:14 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-05 16:12:01 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 20:21:36 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-06 05:49:05 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-06 18:14:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 19:09:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-07 02:23:05 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-07 02:24:33 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-09 13:48:39 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-09-10 01:23:03 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-10 02:45:10 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-10 03:04:58 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-10 14:47:21 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-10 16:27:24 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-11 03:45:24 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-12 09:14:58 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-12 16:32:57 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-10 13:04:01 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-09-11 03:49:25 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-11 04:17:31 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-11 15:24:38 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-09-12 02:51:53 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-12 14:29:21 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-09-15 02:16:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-23 03:25:03 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-23 03:30:58 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2008-09-23 04:05:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-23 04:31:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-23 04:48:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-23 05:15:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-23 12:16:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-23 13:05:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-23 13:13:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-23 13:27:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-23 13:34:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-24 16:04:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-09-24 16:23:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-23 01:57:16 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-23 03:43:14 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-08 14:20:15 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-08 14:49:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-08 08:58:09 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-09-05 01:51:14 from "Alex Hunsaker" <badalex(at)gmail(dot)com>
2008-09-05 02:19:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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
In response to
Responses
pgsql-hackers by date
Next :From: Abhijit Menon-SenDate: 2008-09-06 19:40:55Subject : Re: [PATCH] "\ef <function>" in psqlPrevious :From : Tom LaneDate : 2008-09-06 18:58:25Subject : Re: [PATCH] "\ef <function>" in psql
pgsql-patches by date
Next :From: Bruce MomjianDate: 2008-09-06 19:55:21Subject : Re: still alive?Previous :From : Tom LaneDate : 2008-09-06 18:14:26Subject : Re: hash index improving v3
