Re: Bloated Table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bloated Table
Дата
Msg-id 21548.1243470207@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bloated Table  (Christophe <xof@thebuild.com>)
Список pgsql-general
Christophe <xof@thebuild.com> writes:
> Given this, is there is a recommended way of detecting bloat in
> indices automatically, rather than just looking at them once in a
> while and saying, "Hm, that looks pretty big"?

contrib/pgstattuple works; it's just too expensive to run every
few minutes ...

            regards, tom lane

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

Предыдущее
От: Christophe
Дата:
Сообщение: Re: Bloated Table
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: What is the right way to deal with a table with rows that are not in a random order?