Re: Identifying bloated tables

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Michal Taborsky - Internet Mall <michal(dot)taborsky(at)mall(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Identifying bloated tables
Date: 2006-08-28 14:48:18
Message-ID: 1156776499.10296.5.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ?

Brad.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2006-08-28 14:56:46 Re: Postgre SQL 7.1 cygwin performance issue.
Previous Message Michal Taborsky - Internet Mall 2006-08-28 14:39:30 Identifying bloated tables