Re: Bloated Table

On Wed, 2009-05-27 at 11:15 -0400, Tom Lane wrote:
> =?iso-8859-1?Q?Alexander_Sch=F6cke?= <asc@turtle-entertainment.de> writes:
> > I'm using a view
> > (http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html) to
> > display the bloat (unused disk space) of the tables in a PostgreSQL
> > database.
>
> I wouldn't trust the calculations that view does in the least.
> You might look at contrib/pgstattuple if you want numbers that
> have some relationship to reality (and are correspondingly more
> expensive to get :-()
>
>             regards, tom lane

Is the referenced query reliable for even estimating, or is it flat our
wrong?

Co-workers that were PGCon are saying that this is becoming a
popular/accepted way to check for bloated tables.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.