Re: Idea for reducing planning time - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: Idea for reducing planning time
Date
Msg-id Pine.BSF.4.21.0012132015180.10083-100000@thelab.hub.org
Whole thread Raw
In response to Re: Idea for reducing planning time  (Alfred Perlstein <bright@wintelcom.net>)
Responses Re: Idea for reducing planning time  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
sorry, meant to respond to the original and deleted it too fast ... 

Tom, if the difference between 7.0 and 7.1 is such that there is a
performance decrease, *please* apply the fix ... with the boon that OUTER
JOINs will provide, would hate to see us with a performance hit reducing
that impact ...

One thing I would like to suggest for this stage of the beta, though, is
that a little 'peer review' before committing the code might be something
that would help 'ease' implementing stuff like this and Vadim's VACUUM
code ... read through Vadim's code and see if it looks okay to you ... get
Vadim to read through your code/patch and see if it looks okay to him
... it adds a day or two to the commit cycle, but at least you can say it
was reviewed before committed ...


On Wed, 13 Dec 2000, Alfred Perlstein wrote:

> * Tom Lane <tgl@sss.pgh.pa.us> [001213 15:18] wrote:
> > 
> > I'm trying to resist the temptation to make this change right now :-).
> > It's not quite a bug fix --- well, maybe you could call it a performance
> > bug fix --- so I'm kind of thinking it shouldn't be done during beta.
> > OTOH I seem to have lost the argument that Vadim shouldn't commit VACUUM
> > performance improvements during beta, so maybe this should go in too.
> > What do you think?
> 
> If you're saying that you're OK with the work Vadim has done please
> let him know, I'm assuming he hasn't committed out of respect for your
> still standing objection.
> 
> If you're terribly against it then say so again, I just would rather
> it not happen because you objected rather than missed communication.
> 
> As far as the work you're proposing, how much of a gain is it over
> the current code?  2x? 3x? 20x? :)  There's a difference between a
> slight performance increase and something too good to pass up.
> 
> thanks,
> -- 
> -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
> "I have the heart of a child; I keep it in a jar on my desk."
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Idea for reducing planning time
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: 7.0.3(nofsync) vs 7.1