Re: Identifying bloated tables - Mailing list pgsql-performance

From Brad Nicholson
Subject Re: Identifying bloated tables
Date
Msg-id 1156776499.10296.5.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Responses Re: Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Re: Identifying bloated tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
On Mon, 2006-08-28 at 16:39 +0200, Michal Taborsky - Internet Mall
wrote:
> I just put together a view, which helps us in indentifying which
> database tables are suffering from space bloat, ie. they take up much
> more space than they actually should. I though this might be useful for
> some folk here, because the questions about bloat-related performance
> degradation are quite common.

Are you sure you haven't reinvented the wheel?  Have you checked out
contrib/pgstattuple ?

Brad.


pgsql-performance by date:

Previous
From: Michal Taborsky - Internet Mall
Date:
Subject: Identifying bloated tables
Next
From: Scott Marlowe
Date:
Subject: Re: Postgre SQL 7.1 cygwin performance issue.