Re: Threaded Sorting

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Threaded Sorting
Date: 2002-10-04 19:33:09
Message-ID: 200210041933.g94JX9V09725@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Tom, what temp files do we use that aren't for sorting; I forgot.
>
> MATERIALIZE plan nodes are the only thing I can think of offhand that
> uses a straight temp file. But ISTM that if this makes sense for
> our internal temp files, it makes sense for user-created temp tables
> as well.

Yes, I was thinking that, but of course, those are real tables, rather
than just files. Not sure how clean it will be to mix those in the same
directory. We haven't in the past. Is it a good idea?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Copeland 2002-10-04 19:44:40 Re: Threaded Sorting
Previous Message Bruce Momjian 2002-10-04 19:31:53 Re: Threaded Sorting