Will toast go in the same tablespace as the base table? I can see some advantages to splitting that to another drive for extreme cases (think heap/toast lookups over and over again).
--------------------------------------------------------------------------- Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > >> Sequences are too small to be worth moving around, and may someday be > >> reimplemented in a fashion that doesn't use up a separate disk file for > >> each one. If we allow SET TABLESPACE on them we will be limiting our > >> future flexibility for no useful gain. > > > Why do we allow them to be created in tablespaces in the first place > > then? Seems like a bit of a misfeature? I mean we don't allow views in > > tablespaces... > > I had forgotten that the original patch allowed that. Personally I'd > vote for taking it out, for the above-stated reasons --- any objections? > > If people do want to have it then we can instead change ALTER SET > TABLESPACE to allow sequences; but we'd also need a nontrivial addition > to pg_dump, so there had better be a better reason than "might be nice > to have". > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- 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