PostgreSQL 8.0 brought a great tablespaces feature. However, it's still
a real pain for one who wants to separate tables and indices to different
tablespaces: he has to do it manually, explicitely specifying tablespace
for each index.
Thus, I think it would be handy to have "default_index_tablespace" server
variable. Any thoughts?

TD?

%Add default_index_tablespace GUC and database parameter.

Thu, Dec 01, 2005 at 11:48:28AM -0600, Kelly Burkhart wrote:
12/1/05, Alexander M. Pravking <fduch (AT) antar (DOT) bryansk.ruwrote:

PostgreSQL 8.0 brought a great tablespaces feature. However, it's still
a real pain for one who wants to separate tables and indices to different
tablespaces: he has to do it manually, explicitely specifying tablespace
for each index.

Thus, I think it would be handy to have "default_index_tablespace" server
variable. Any thoughts?

We would use such a thing. databases use three partitions: log, data,
index. We currently create our databases like:

CREATE DATABASE dbname WNER owner TABLESPACE tsname;

We then specify another index tablespace on index creation (which really
isn't that difficult).

Adding an INDEX_TABLESPACE option to CREATE DATABASE might be worthwhile if
what we have done is typical. if pg maintainers want to suggest this
usage as sensible.
-K

Fri, Dec 02, 2005 at 06:06:25PM -0500, Tom Lane wrote:
"Jim C. Nasby" <jim (AT) nasby (DOT) netwrites:
TD?
%Add default_index_tablespace GUC and database parameter.

That was part of the original tablespace proposal and was rejected for
(what seemed at the time) good reasons. It'd be nice if this thread
betrayed any awareness whatsoever of the previous discussions

Any idea on what to search for? 'default index tablespace' isn't turning
up anything that looks like that discussion