Re: space not reclaimed after repeated full vacuums

From: Tom O'Brien <Tom(dot)OBrien(at)entrust(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: space not reclaimed after repeated full vacuums
Date: 2006-07-04 20:49:14
Message-ID: 7A3E1242FA9989439AD1F9B2D71C287F0B6B6C82@sottmxs05.entrust.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I left this running over the weekend, and was surprised to
> find the script still running in it's 25th iteration this
> morning, with basically no rows left in any of the non-static tables.
>
> The interesting thing was that the data partition still had
> almost 26GB of space used, no matter how much data was
> actually in the database.

FYI: I discovered the REINDEX command, and after calling REINDEX on all
non-static tables that I'd been deleting from, I got back to roughly my
starting point (176MB from 26GB!).

Whoa!

Browse pgsql-admin by date

  From Date Subject
Next Message Aaron Bono 2006-07-04 20:55:19 Re: Wrap (obfuscate) code
Previous Message Tom O'Brien 2006-07-04 19:47:44 space not reclaimed after repeated full vacuums