From: MirrorX <mirrorx@gmail.com>
To: pgsql-admin@postgresql.org
Subject: alter index's tablespace (from default) after pg_upgrade --link
Date: Wed, 4 Apr 2012 04:51:49 -0700 (PDT)
Message-ID: <1333540309862-5617549.post@n5.nabble.com> (raw)
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-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mirrorx@gmail.com
Subject: Re: alter index's tablespace (from default) after pg_upgrade --link
In-Reply-To: <1333540309862-5617549.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox