Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
Finding bloated indexes?
- From: Dan Harris <fbsd(at)drivefaster(dot)net>
- To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Finding bloated indexes?
- Date: Fri, 13 Apr 2007 14:01:40 -0600
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.
Thanks -Dan
- Follow-Ups:
- Re: Finding bloated indexes?
- From: Simon Riggs
- Re: Finding bloated indexes?
- From: Vivek Khera
- Re: Finding bloated indexes?
- Prev by Date: Re: Question about memory allocations
- Next by Date: Re: Question about memory allocations
- Previous by thread: local selectivity estimation - computing frequency of predicates
- Next by thread: Re: Finding bloated indexes?
- Indexes: