BTW: Is there a public spec on what will be tablespace compatible and how? For instance: will is be possible to create a table on a separate tablespace than the DB? Will it be possible to create an index on a separate tablespace than the table?
(Since Gavin hasn't replied yet)
1. There are two default tablespaces, global and default. Global is for shared catalogs, default is for all other catalog data.
2. By default databases are created in the default tablespace, you can override this.
3. By default schemas are created in the database's tablepsace, but this can be overridden.
5. Tables and sequences are created in the schema's tablespace by default, but this can be overridden
6. Indexes and SERIAL sequences are created in the table's tablespace by default, but this can be overridden.
When pg_dumping, care is taken so that the tablespace qualification is only dumped if the object is in its 'non-default' tablespace.
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
