Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Finding bloated indexes?
- From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
- To: "Dan Harris" <fbsd(at)drivefaster(dot)net>
- Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Finding bloated indexes?
- Date: Sat, 14 Apr 2007 09:27:25 +0100
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
- References:
- Finding bloated indexes?
- From: Dan Harris
- Finding bloated indexes?
- Prev by Date: Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance)
- Next by Date: Basic Q on superfluous primary keys
- Previous by thread: Re: Finding bloated indexes?
- Next by thread: Basic Q on superfluous primary keys
- Indexes: