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. +