Andreas Pflug <[EMAIL PROTECTED]> writes: > I could think of cases where temporary schemas should go to a different > tablespace, but AFAICS since these are created implicitely there's no > way to redirect them. Maybe an additional attribute in pg_database for a > default temp tablespace is desirable?
By default, temp tables will live in the database's default tablespace, which is not necessarily the pg_default tablespace. (Hmm, there's another good reason for renaming it ... if I'd said "default" tablespace I'd have had to go out of my way to make it clear what I meant.) This arguably is sufficient control. In any case, I'd prefer not to add a knob to relocate temp stuff until there's proven need for it. We can always add features later, but inventing stuff because somebody might need it is a recipe for overdesign. (Remember that you can always redirect a specific temp table to a specific tablespace when you create it.) The other thing I think people might possibly want to move around is pg_largeobject. If Gavin finishes ALTER TABLE SET TABLESPACE (or whatever we call it), that should provide a sufficient answer there. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings