From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-admin@postgresql.org
Subject: Migrating tables to new tablespace, freed up space doesn't match moved data
Date: Wed, 20 Feb 2013 14:15:32 -0700
Message-ID: <51253CF4.3030706@consistentstate.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
I've set up a tablespace on a different partition from the main data
directory. I moved a few tables and indexes over to the new tablespace
and the disk space used in this new tablespace doesn't match the amount
of data 'freed up' from the main data directory. The tablespace is
sitting at 15 GB used, but the space freed up on the main partition is
about 10 GB.
Any thoughts as to why I didn't see as much space freed up as I thought
I would?
Thanks,
- Brian F
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: brianf@consistentstate.com
Subject: Re: Migrating tables to new tablespace, freed up space doesn't match moved data
In-Reply-To: <51253CF4.3030706@consistentstate.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