Re: [HACKERS] Autovacuum loose ends

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Autovacuum loose ends
Дата
Msg-id 18143.1122665589@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: [HACKERS] Autovacuum loose ends
Re: [HACKERS] Autovacuum loose ends
Re: [HACKERS] Autovacuum loose ends
Список pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Updated this patch:
> - The stat collector is modified so as to keep shared relations separate
>   from regular ones.  Autovacuum understands this.
>   [etc]

Applied with some fixes --- you had broken the reporting of statistics
for shared tables, for one thing.  Also the patch seemed to be missing
diffs for header files?

It occurs to me that vacuuming to prevent XID wraparound is not the only
reason to do DB-wide vacuums: we also need to keep
pg_database.datvacuumxid from getting too old, else we will have
problems with clog bloat.  We may need to rethink the test used.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Patch to mention cost-based delay in vacuum reference
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Autovacuum loose ends