Re: Bloated Table - Mailing list pgsql-general

From Tom Lane
Subject Re: Bloated Table
Date
Msg-id 10728.1243437335@sss.pgh.pa.us
Whole thread Raw
In response to Bloated Table  (Alexander Schöcke <asc@turtle-entertainment.de>)
Responses Re: Bloated Table  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-general
=?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

pgsql-general by date:

Previous
From: Alexander Schöcke
Date:
Subject: Bloated Table
Next
From: Scott Bailey
Date:
Subject: Re: composite type and domain