About 3 hours after the Vacuum full completed, the disk space got returned to the OS - now Windows is reporting it has all that disk back. Must have been waiting for something? Anyway, great news!
On Mon, May 28, 2012 at 11:23 PM, Anthony Bull
<antsbull@gmail.com> wrote:
I did not run analyze, only vacuum full - the disk usage reported by the OS has stayed the same also - the data folder under postgres is still at over 25GB. Postgres itself also still reports db size at 25GB, but when I ask postgres for a table breakdown by size, it reports only about 9GB of tables in the db.
Will analyze help? I was under the impression that was more for statistics gathering and index optimising?