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 <antsb...@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? > > On Mon, May 28, 2012 at 11:16 PM, Jens Wilke <j...@wilke.org> wrote: > >> On Montag, 28. Mai 2012, Anthony Bull wrote: >> >> Hi, >> >> >This did not >> > work either - postgres still reports 25GB being used by the >> > database. >> >> Did you run analyze? >> Did the disk usage reported by the OS shrink? >> >> Regards, Jens >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
