Re: [PATCH]-hash index improving - Mailing list pgsql-hackers

From Kenneth Marshall
Subject Re: [PATCH]-hash index improving
Date
Msg-id 20080717175418.GK337@it.is.rice.edu
Whole thread Raw
In response to Re: [PATCH]-hash index improving  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [PATCH]-hash index improving  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: [PATCH]-hash index improving  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Thu, Jul 17, 2008 at 12:42:39PM -0400, Alvaro Herrera wrote:
> Xiao Meng escribi?:
> > The patch store hash code only in the index tuple.
> > It based on  Neil Conway's patch with an old version of PostgreSQL.
> > It passes the regression test but I didn't test the performance yet.
> > Anyone interested can make a performance test;-)
> > You can undefine the macro HASHVALUE_ONLY in hash.h to get the
> > original implementation.
> 
> I think having the HASHVALUE_ONLY define is not a good idea -- it just
> makes the patch harder to read.  I suggest just removing the old code
> and putting the new code in place.  (That's why we have revision
> control.)
> 
One thing it helps is building an old version and a new version
for comparative testing. Otherwise, you could end up with an apples-to-
oranges comparison. I certainly think that the final patch should not
have it, but it is useful now for testing and comparisons.

My two cents,
Ken


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: [PATCH]-hash index improving
Next
From: Kenneth Marshall
Date:
Subject: Re: [PATCH]-hash index improving