Re: how much free space in tables and index ?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: maa1666(at)yahoo(dot)fr, pgsql-general(at)postgresql(dot)org
Subject: Re: how much free space in tables and index ?
Date: 2006-09-24 22:30:40
Message-ID: 200609242230.k8OMUea12939@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr wrote:
> On Fri, Sep 22, 2006 at 02:11:40AM -0700, maa1666(at)yahoo(dot)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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-09-24 22:49:22 Re: column names in select don't exists in insert to
Previous Message Bob Pawley 2006-09-24 22:29:14 Re: serial column