how much free space in tables and index ?

On Fri, Sep 22, 2006 at 02:11:40AM -0700, maa1666@yahoo.fr wrote:

When tuples are deleted, there remains free space in table and index
files.
Is it possible to know for each table and index how much free space it
contains ?

For tables see the contrib/pgstattuple module.

--
Michael Fuhr

Michael Fuhr wrote:

On Fri, Sep 22, 2006 at 02:11:40AM -0700, maa1666@yahoo.fr wrote:

When tuples are deleted, there remains free space in table and index
files.
Is it possible to know for each table and index how much free space it
contains ?

For tables see the contrib/pgstattuple module.

And that will work for indexes in 8.2.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +