Migrating tables to new tablespace, freed up space doesn't match moved data

From: Brian Fehrle <brianf(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Migrating tables to new tablespace, freed up space doesn't match moved data
Date: 2013-02-20 21:15:32
Message-ID: 51253CF4.3030706@consistentstate.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Prashanth Ranjalkar 2013-02-21 01:40:06 Re: Pg 9.1 master-slave replication
Previous Message Viktor 2013-02-20 16:04:31 Re: Pg 9.1 master-slave replication