> BTW, it occurs to me that we ought to have some frammish whereby temp
> files and tables created by backends running in a particular database
> can be directed to a different tablespace. If we do nothing, then
> they'd always appear in the database's home tablespace, but I can sure
> see a dbadmin wanting to push his large sort temp files off to someplace
> else...
Sort tables are an area Ingres does round-robin so the tape file can be
on different drives.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026