Re: Free Space after vacuuming

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Free Space after vacuuming
Дата
Msg-id 4BB37C9602000025000302CB@gw.wicourts.gov
обсуждение исходный текст
Ответ на Free Space after vacuuming  ("Naomi Walker" <nwalker@mhs.mphasis.com>)
Список pgsql-admin
"Naomi Walker" <nwalker@mhs.mphasis.com> wrote:

> How does one tell how much space is available (probably by table),
> after a "vacuum verbose analyze" has completed.

Personally, I mostly pay attention to these lines:

NNNNN pages contain useful free space.

(where NNNNN is a large number).

We grep for large numbers in the file where we've redirected the
nightly VACUUM ANALYZE VERBOSE output, and if we find something we
email our DBA team.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Statistics Collector not collecting server activities
Следующее
От: Mario Splivalo
Дата:
Сообщение: Re: Live sort-of-'warehousing' database how-to?