Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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.
OK, TODO updated: * Allow sorting, temp files, temp tables to use multiple work directories FYI, I originally created that directory so a postmaster startup could clear that dir. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly