From: Alvaro Herrera <alvherre@commandprompt.com>
To: Brad Nicholson <bnichols@ca.afilias.info>
Cc: Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Identifying bloated tables
Date: Mon, 28 Aug 2006 11:31:52 -0400
Message-ID: <20060828153152.GH27526@alvh.no-ip.org> (raw)
In-Reply-To: <1156776499.10296.5.camel@dba5.int.libertyrms.com>
References: <44F30022.1000009@mall.cz>
<1156776499.10296.5.camel@dba5.int.libertyrms.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, bnichols@ca.afilias.info, michal.taborsky@mall.cz
Subject: Re: Identifying bloated tables
In-Reply-To: <20060828153152.GH27526@alvh.no-ip.org>
References: <44F30022.1000009@mall.cz> <1156776499.10296.5.camel@dba5.int.libertyrms.com> <20060828153152.GH27526@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox