Re: Threaded Sorting - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Threaded Sorting
Date
Msg-id 200210041933.g94JX9V09725@candle.pha.pa.us
Whole thread Raw
In response to Re: Threaded Sorting  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Threaded Sorting  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Threaded Sorting
Next
From: Greg Copeland
Date:
Subject: Re: Threaded Sorting