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. Our databases use three partitions: log, data, index. We currently create our databases like:
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. Or if pg maintainers want to suggest this usage as sensible.