Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Fuhr
Subject Re: how much free space in tables and index ?
Date
Msg-id 20060924222840.GA42916@winnie.fuhr.org
Whole thread Raw
In response to how much free space in tables and index ?  (maa1666@yahoo.fr)
Responses Re: how much free space in tables and index ?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: serial column
Next
From: Bob Pawley
Date:
Subject: Re: serial column