dear all, i have come to face the following situation: -initially the server was 8.4.7 -i used pg_upgrade --link so that the upgrade would be quick -i created a new tablespace with the intention of moving all the indexes there (different partition) -when issueing a statement like 'alter index xxxx set tablespace new_tblsp' the data files of the index are moved to the new tablespace but the original files remain also on the data_8.4/base directory i tried on a test environment to manually delete the datafiles from the old location and there didn't seem to be any problem from the tests i made (full scan of the table using the specific index,vacuum etc)... so my questions are the following: 1)is this the expected behavior when altering an index whose data files come from a link on pg_upgrade? 2)if so, is it safe to manually 'delete' the old datafiles? 3)is there any other way of doing this procedure?i am in the process of trying to drop the old index to check if the space will be released. if so, i guess i could create it directly onto the new tablespace thx in advance for your insight -- View this message in context: http://postgresql.1045698.n5.nabble.com/alter-index-s-tablespace-from-default-after-pg-upgrade-link-tp5617549p5617549.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
