Re: postmaster(s) have high load average

Поиск
Список
Период
Сортировка
От Claudio Lapidus
Тема Re: postmaster(s) have high load average
Дата
Msg-id BAY7-DAV44o4yjuOxjZ0001505a@hotmail.com
обсуждение исходный текст
Ответ на postmaster(s) have high load average  (Chris Webster <cjw@ucar.edu>)
Ответы Re: postmaster(s) have high load average
Список pgsql-general
> Run VACUUM VERBOSE on it; you'll no doubt see that some internal
> tables such as pg_activity, pg_statistic, and such have a lot of dead
> tuples.  Establishing a connection leads to _some_ DB activity, and
> probably a dead tuple or two; every time you ANALYZE, you create a
> bunch of dead tuples since old statistics are "killed off."

What? Does this mean that it is needed to routinely vacuum system tables
too? If so, which is the recommended procedure?

thx
cl.

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: postmaster(s) have high load average
Следующее
От: Phil Howard
Дата:
Сообщение: Continued mail server problems for all PGSQL mailing lists I'm on