Re: Idea for reducing planning time

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Idea for reducing planning time
Date: 2000-12-14 00:21:58
Message-ID: Pine.BSF.4.21.0012132015180.10083-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-12-14 00:46:51 Re: Idea for reducing planning time
Previous Message Mikheev, Vadim 2000-12-14 00:14:17 RE: 7.0.3(nofsync) vs 7.1