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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted
Дата
Msg-id CAMkU=1yic6ADT9mSHQGzdUtzsp6u9R8xwzFv6Yj=ijVMXXGRvA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted  (Max Vikharev <bm.kinder@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Oct 29, 2020 at 5:44 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16691
Logged by:          Max Vikharev
Email address:      bm.kinder@gmail.com
PostgreSQL version: 12.3
Operating system:   Ubuntu 16.04.5 LTS
Description:       

Hi,

Previously i've reported BUG # 16620. But there is no answer on my new
mails, so i have to open this new report.

Currently we have to restart postgresql 12.3 every 5-7 days to make it  work
properly on 5 terabyte cluster with ~ 50 databases. The problem is that
autovacuum stops to process certain databases and cycles on the only one...
Until we restart cluster.

There is a known problem (https://www.postgresql.org/message-id/CAMkU=1yE4YyCC00W_GcNoOZ4X2qxF7x5DUAR_kMt-Ta=YPyFPQ@mail.gmail.com) that looks something like this, but restarting the database should not fix it (or at least, not for long), and it should stop on its own once the one database being vacuumed for wraparound has finished doing so.  Is it vacuuming the same table over and over again, or is finishing that table and moving to another in the same database, or what?

Cheers,

Jeff

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #16692: Postgres process using 100 percent CPU
Следующее
От: Max Vikharev
Дата:
Сообщение: Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted