Re: [HACKERS] Autovacuum loose ends

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Autovacuum loose ends
Дата
Msg-id 21280.1123794795@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Updated this patch again:

> - vacuum_cost_delay and vacuum_cost_limit can be set per table, as well
> as globally with autovacuum_vacuum_cost_{limit,delay}
>
> - pgstat is reset if recovery is required
>
> - pgstat reset at postmaster start is disabled by default
>
> - Xid-wraparound VACUUM is now FREEZE without ANALYZE, iff the database
> has datallowconn=false or datistemplate=true
>
> - A database-wide vacuum is also issued if the vacuumxid is found to be
>   very old.

Applied with minor tweaks --- mostly, fixing it so the custom cost
settings are applied for ANALYZE as well as VACUUM.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] O_DIRECT for WAL writes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] For review: Server instrumentation patch