Default tablespace for indexes in postgres
Posted
by tom
on Stack Overflow
See other posts from Stack Overflow
or by tom
Published on 2010-06-07T21:24:28Z
Indexed on
2010/06/08
21:42 UTC
Read the original article
Hit count: 170
postgresql
|django-models
Just wondering if its possible to set a default tablespace in postgres to keep indexes. Would like the databases to live on the default tablespace for postgres, however, would like to get the indexes on a different set of disks just to keep the i/o traffic separated.
It does not appear to me that it can be done without going in and doing an ALTER index TABLESPACE command, and then the index is moved and will stay there, but the databases and indexes are part of a django app, so non-django intervention can cause some problems.
© Stack Overflow or respective owner