Re: Index bloat, reindex weekly, suggestions etc?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Index bloat, reindex weekly, suggestions etc?
Дата
Msg-id dcc563d10810171002j6e5491d4nb46e5dca8159698c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index bloat, reindex weekly, suggestions etc?  ("Tory M Blue" <tmblue@gmail.com>)
Ответы Re: Index bloat, reindex weekly, suggestions etc?
Список pgsql-performance
On Fri, Oct 17, 2008 at 10:47 AM, Tory M Blue <tmblue@gmail.com> wrote:
> DETAIL:  A total of 501440 page slots are in use (including overhead).
> 501440 page slots are required to track all free space.
> Current limits are:  1087500 page slots, 430 relations, using 6401 kB.
> VACUUM
>
> that looks fine

That's still a lot of dead space.  You might do better with more
aggresive autovacuuming settings.

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

Предыдущее
От: "Tory M Blue"
Дата:
Сообщение: Re: Index bloat, reindex weekly, suggestions etc?
Следующее
От: "Tory M Blue"
Дата:
Сообщение: Re: Index bloat, reindex weekly, suggestions etc?