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