Gavin Sherry wrote: > > One downside that came up yesterday in a discussion is that once shemas > > don't have default tablespaces we can't easily have default tablespaces > > for toast and temporary table system schemas. Now we can't actually do > > that now anyway because they are created by the system but it might > > limit how we can control these in the future. I am just throwing this > > out as a point. > > Neil has been talking to me about being able to set a tablespace for > temporary tables at or after create database time. > > 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. -- 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 8: explain analyze is your friend