Postgres Pro
Downloads
Home   >   mailing lists

Re: how much free space in tables and index ? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: how much free space in tables and index ?
Date
Msg-id 200609242230.k8OMUea12939@momjian.us
Whole thread Raw
In response to Re: how much free space in tables and index ?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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. +

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: serial column
Next
From: Michael Fuhr
Date:
Subject: Re: column names in select don't exists in insert to