Re: Finding bloated indexes?

Список
Период
Сортировка
От Simon Riggs
Тема Re: Finding bloated indexes?
Дата
Msg-id 1176539246.3635.317.camel@silverbirch.site
обсуждение исходный текст
Ответ на Finding bloated indexes?  (Dan Harris)
Список pgsql-performance
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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Basic Q on superfluous primary keys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance)