pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrating tables to new tablespace, freed up space doesn't match moved data
2+ messages / 2 participants
[nested] [flat]
* Migrating tables to new tablespace, freed up space doesn't match moved data
@ 2013-02-20 21:15 Brian Fehrle <brianf@consistentstate.com>
0 siblings, 1 reply; 2+ messages in thread
From: Brian Fehrle @ 2013-02-20 21:15 UTC (permalink / raw)
To: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Migrating tables to new tablespace, freed up space doesn't match moved data
@ 2013-02-21 01:41 Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
parent: Brian Fehrle <brianf@consistentstate.com>
0 siblings, 0 replies; 2+ messages in thread
From: Prashanth Ranjalkar @ 2013-02-21 01:41 UTC (permalink / raw)
To: Brian Fehrle <brianf@consistentstate.com>; +Cc: pgsql-admin
When any files that are in large size moved out or deleted, the reclaiming
of the space at certain operating system level may not be fast enough as
soon as the operation is completed and may take time.. Another possibility
would be that stats are not updated, worth to analyze the tables that are
moved into tablespace.
**
*Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*www.postgresdba.net*
On Thu, Feb 21, 2013 at 2:45 AM, Brian Fehrle <brianf@consistentstate.com>wrote:
> 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<http://www.postgresql.org/mailpref/pgsql-admin;
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-02-21 01:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-02-20 21:15 Migrating tables to new tablespace, freed up space doesn't match moved data Brian Fehrle <brianf@consistentstate.com>
2013-02-21 01:41 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
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