Brad Nicholson wrote:
> 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 ?
Actually, pgstattuple needs to scan the whole table, so I think having a
cheap workaround that gives approximate figures is a good idea anyway.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.