From: Simon Riggs <simon@2ndquadrant.com>
To: Dan Harris <fbsd@drivefaster.net>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Finding bloated indexes?
Date: Sat, 14 Apr 2007 09:27:25 +0100
Message-ID: <1176539246.3635.317.camel@silverbirch.site> (raw)
In-Reply-To: <461FE1A4.70908@drivefaster.net>
References: <461FE1A4.70908@drivefaster.net>
On Fri, 2007-04-13 at 14:01 -0600, Dan Harris wrote:
> Is there a pg_stat_* table or the like that will show how bloated an index is?
> I am trying to squeeze some disk space and want to track down where the worst
> offenders are before performing a global REINDEX on all tables, as the database
> is rougly 400GB on disk and this takes a very long time to run.
>
> I have been able to do this with tables, using a helpful view posted to this
> list a few months back, but I'm not sure if I can get the same results on indexes.
Use pgstatindex in contrib/pgstattuple
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
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: simon@2ndquadrant.com, fbsd@drivefaster.net
Subject: Re: Finding bloated indexes?
In-Reply-To: <1176539246.3635.317.camel@silverbirch.site>
* 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