Michael Fuhr wrote: > On Fri, Sep 22, 2006 at 02:11:40AM -0700, [EMAIL PROTECTED] 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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
