Re: Tablespace patch review

Andreas Pflug <pgadmin@pse-consulting.de> 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