Re: Vacuuming of indexes on tables.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuuming of indexes on tables.
Дата
Msg-id 12663.1145368204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuuming of indexes on tables.  (elein <elein@varlena.com>)
Ответы Re: Vacuuming of indexes on tables.  (elein <elein@varlena.com>)
Список pgsql-general
elein <elein@varlena.com> writes:
> Much later in the day, a vacuum analyze of the
> db showed that all of the indexes for that table
> required significant vacuuming, although the
> table did not.

What do you mean by that exactly?  If it's just that the index pages
emptied by one VACUUM aren't actually recycled till the next one,
that's by design.

            regards, tom lane

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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Syntax Help Requested -- RESOLVED
Следующее
От: Alexander Scholz
Дата:
Сообщение: Query to check existence of stored procedure?