Re: Bloated Table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Schöcke <asc(at)turtle-entertainment(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bloated Table
Date: 2009-05-27 15:15:35
Message-ID: 10728.1243437335@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Alexander_Sch=F6cke?= <asc(at)turtle-entertainment(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-05-27 15:23:36 Re: composite type and domain
Previous Message Bill Moran 2009-05-27 15:09:50 Re: Bloated Table