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
In response to
pgsql-performance by date
|Next:||From: Dann Corbit||Date: 2007-04-14 09:04:24|
|Subject: Re: choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)|
|Previous:||From: Simon Riggs||Date: 2007-04-14 08:24:07|
|Subject: Re: choose_bitmap_and again (was Re: [PERFORM] StrangelyVariable Query Performance)|