Re: tuning autovacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tuning autovacuum
Дата
Msg-id 16306.1307655717@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: tuning autovacuum  (Greg Smith <greg@2ndQuadrant.com>)
Ответы Re: tuning autovacuum  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-hackers
Greg Smith <greg@2ndQuadrant.com> writes:
> What we'd probably need to do with those is handle them like the other 
> stats in the system:  store a total number for visited/cleaned/dead for 
> each relation, then increment the total as each vacuum finishes.

As Robert said, we're already seeing scalability problems with the
pg_stats subsystem.  I'm not eager to add a bunch more per-table
counters, at least not without some prior work to damp down the ensuing
performance hit.
        regards, tom lane


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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: On-the-fly index tuple deletion vs. hot_standby
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Postmaster holding unlinked files for pg_largeobject table