From: Brad Nicholson <bnichols@ca.afilias.info>
To: Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Identifying bloated tables
Date: Mon, 28 Aug 2006 10:48:18 -0400
Message-ID: <1156776499.10296.5.camel@dba5.int.libertyrms.com> (raw)
In-Reply-To: <44F30022.1000009@mall.cz>
References: <44F30022.1000009@mall.cz>
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.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bnichols@ca.afilias.info, michal.taborsky@mall.cz
Subject: Re: Identifying bloated tables
In-Reply-To: <1156776499.10296.5.camel@dba5.int.libertyrms.com>
* 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