Re: tablespaces for temporary files

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Greg Stark wrote:
> >> Actually the sort algorithm postgres uses would be much more efficient if it
> >> could get access to two or three locations guaranteed to be on different
> >> spindles.
> 
> > Agreed, and I was going to mention the idea of a round-robin allocation
> > setup where the system cycles through a list of possible locations for
> > both sort files and temporary tables.
> 
> Greg's point was that sort would want to *know* that it created three
> temp files on three different devices.  Throwing random effects of other
> sessions into the mix wouldn't make it better.

OK, let's say the sort starts on a random tablespace and then goes
sequentially through the list:* Add a GUC variable to control the tablespace for temporary objects and  sort files  It
couldstart with a random tablespace from a supplied list and cycle  through the list.
 

--  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