Postgres Pro
Downloads
Home   >   mailing lists

Free Space after vacuuming - Mailing list pgsql-admin

From Naomi Walker
Subject Free Space after vacuuming
Date
Msg-id BAE9D9FB729AAE4A8FE35F8A82AAA8AE9078DA@winmail.eldocomp.com
Whole thread Raw
In response to Re: postgres 8.2.9 transaction id wraparound failure  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Free Space after vacuuming  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
All,

How does one tell how much space is available (probably by table), after
a
"vacuum verbose analyze" has completed.  As I understand it, the emptied

space will still be only available to the table that originally housed
it.

We are running Postgresql 8.3 in various Solaris and Linux environments.

Thanks,
Naomi

pgsql-admin by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Live sort-of-'warehousing' database how-to?
Next
From: Tom Lane
Date:
Subject: Re: Statistics Collector not collecting server activities