Re: space not reclaimed after repeated full vacuums - Mailing list pgsql-admin

From Tom O'Brien
Subject Re: space not reclaimed after repeated full vacuums
Date
Msg-id 7A3E1242FA9989439AD1F9B2D71C287F0B6B6C82@sottmxs05.entrust.com
Whole thread Raw
In response to space not reclaimed after repeated full vacuums  (Tom O'Brien <Tom.OBrien@entrust.com>)
List 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!

pgsql-admin by date:

Previous
From: Tom O'Brien
Date:
Subject: space not reclaimed after repeated full vacuums
Next
From: "Aaron Bono"
Date:
Subject: Re: Wrap (obfuscate) code