Re: autovacuum not prioritising for-wraparound tables

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: autovacuum not prioritising for-wraparound tables
Дата
Msg-id 1359570067.32849.YahooMailNeo@web162901.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: autovacuum not prioritising for-wraparound tables  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: autovacuum not prioritising for-wraparound tables  (Andres Freund <andres@2ndquadrant.com>)
Re: autovacuum not prioritising for-wraparound tables  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> wrote:

> I can't imagine that anybody with a large database ran pg
> successfully with a small freeze_min_age due to this.

I can't speak to this from personal experience, because at
Wisconsin Courts we found ourselves best served by running a
database VACUUM FREEZE ANALYZE each night during off-peak hours.

> It seems to be broken since the initial introduction of
> freeze_table_age in 6587818542e79012276dcfedb2f97e3522ee5e9b.

> Trivial patch attached.

I didn't see a patch attached.

-Kevin



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

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: lazy_vacuum_heap()'s removal of HEAPTUPLE_DEAD tuples
Следующее
От: Andres Freund
Дата:
Сообщение: Re: autovacuum not prioritising for-wraparound tables