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: 177

Filed under:
|

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

Related posts about postgresql

Related posts about django-models