OK, TODO updated: * Add a GUC variable to control the tablespace for temporary objects
--------------------------------------------------------------------------- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Gavin Sherry wrote: > >> I'm not sure about TOAST however. I considered the idea of adding > >> something to CREATE TABLE like TOASTSPACE <tablespace>, such that all > >> TOAST tables would be put in the 'toastspace'. But I think the syntax is > >> ugly and would confuse many users who do not know what toast is. > > > I think we need to add temp_tablespace and toast_tablespace GUC > > variables to deal with this, perhaps for 8.1. > > A tablespace for temp tables is okay, but I'm fairly dubious about the > idea of a "toast tablespace". The current behavior is that a toast > table is automatically placed into the same tablespace as its parent, > and that seems exactly right to me. It's certainly the right thing from > the point of view of users who do not understand TOAST and expect all of > a table's data to get put where they said to put the table. > > regards, tom lane > -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]