I received this from Paul Aoki this afternoon.
Forwarded message:
> From aoki@postgres.Berkeley.EDU Sun Jun 22 19:31:06 1997
> Message-Id: <199706222316.QAA07816@faerie.CS.Berkeley.EDU>
> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
> From: aoki@CS.Berkeley.EDU (Paul M. Aoki)
> To: Bruce Momjian <maillist@candle.pha.pa.us>
> Subject: Re: PostgreSQL psort() function performance
> Reply-To: aoki@CS.Berkeley.EDU (Paul M. Aoki)
> In-reply-to: Your message of Sun, 22 Jun 1997 09:45:31 -0400 (EDT)
> <199706221345.JAA11476@candle.pha.pa.us>
> Date: Sun, 22 Jun 97 16:16:43 -0700
> Sender: aoki@postgres.Berkeley.EDU
> X-Mts: smtp
>
> the mariposa distribution (http://mariposa.cs.berkeley.edu/) contains
> some hacks to nodeSort.c and psort.c that
> - make psort read directly from the executor node below it
> (instead of an input relation)
> - makes the Sort node read directly from the last set of psort runs
> (instead of an output relation)
> speeds things up quite a bit. kind of ruins psort for other purposes,
> though (which is why nbtsort.c exists).
>
> i'd merge these in first and see how far that gets you.
> --
> Paul M. Aoki | University of California at Berkeley
> aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division #1776
> | Berkeley, CA 94720-1776
>
- --
Bruce Momjian
maillist@candle.pha.pa.us
------------------------------