[HACKERS] Re: PostgreSQL psort() function performance (fwd) - Mailing list pgsql-hackers

From Bruce Momjian
Subject [HACKERS] Re: PostgreSQL psort() function performance (fwd)
Date
Msg-id 20381cda98ead2d01e33ecb81003714f
Whole thread Raw
List pgsql-hackers
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

------------------------------

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] \dt and disk access
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] \dt and disk access