Re: Identifying bloated tables

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.