Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted
Дата
Msg-id 387272.1604250098@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted  (Max Vikharev <bm.kinder@gmail.com>)
Ответы Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted  (Max Vikharev <bm.kinder@gmail.com>)
Список pgsql-bugs
Max Vikharev <bm.kinder@gmail.com> writes:
>> finishing that table and moving to another in the same database

> Yes, that case. Vacuum processes relations in one database In cycle

It sounds like it's failing to advance that database's datfrozenxid
and/or datminmxid.  You might try to figure out which table is holding
those values back by comparing pg_class.relfrozenxid and relminmxid
to those pg_database columns.  Then look to see if autovacuum is
failing on that table, and/or try a manual vacuum to see what happens.

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring