create tablespace 'name' owner 'owner' location 'directory'
and than creating a quick script to move all the indexes
select 'ALTER INDEX '||indexname||' SET TABLESPACE compoundindex ;' from pg_catalog.pg_indexes where schemaname = 'public' order by tablename;
which than just needs to be executed
No comments:
Post a Comment