RE: Temporary tables prevent autovacuum, leading to XID wraparound

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Temporary tables prevent autovacuum, leading to XID wraparound
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F8AD84F@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: Temporary tables prevent autovacuum, leading to XID wraparound  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
From: Masahiko Sawada [mailto:sawada.mshk@gmail.com]
> Thank you for suggestion. It sounds more smarter. So it would be more better
> if we vacuums database for anti-wraparound in ascending order of
> relfrozenxid?

I thought so, too.  The current behavior is inconsistent: the launcher tries to assign all workers to one database with
thebiggest wraparound risk in order to eliminate the risk as fast as possible, but the workers don't get hurry to
reducethe risk.
 

Regards
Takayuki Tsunakawa



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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Следующее
От: Amit Khandekar
Дата:
Сообщение: Re: Query running for very long time (server hanged) with parallel append