Space usage - Mailing list pgsql-admin

From Anantha V Padmanaban
Subject Space usage
Date
Msg-id SNT108-W23672D71DA40332113DBA3D4070@phx.gbl
Whole thread Raw
Responses Re: Space usage  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Hi All

Version 8.1

I am new to postgres and trying to find a way to get the actual space usage of a table. The table size is 28GB but I have deleted a lot of rows which is not getting reflected. I presume the space will be reclaimed after the vacuum process. But I would like to know how much space left in the database. Is there anyway we can find how much space will be released after vacuuming process?

Thanks
AP





Match ‘n’ Make new friends with the cool match-meter. Join the Planet with you Hotmail ID. Drag n’ drop

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: XID wraparound in 8.4
Next
From: Anj Adu
Date:
Subject: Re: XID wraparound in 8.4