| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(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:51:36 |
| Message-ID: | 26219.1033761096@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> ... 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?
Sure we have --- up till recently, pg_temp files just lived in the
database directory. I think it was you that added the pg_temp
subdirectory, and the reason you did it was to let people symlink the
temp files to someplace else. But that's just a zeroth-order
approximation to providing a tablespace facility for these things.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-04 20:07:12 | Re: Threaded Sorting |
| Previous Message | Curtis Faith | 2002-10-04 19:48:40 | Re: Potential Large Performance Gain in WAL synching |