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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
