Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted - Mailing list pgsql-bugs

From Max Vikharev
Subject Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted
Date
Msg-id CACRpr1NLVbQ9o+Kv=R-CzO9fgtZAjKVoMHdmfPDoMrkDJYsyrA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted
List pgsql-bugs
Hi
Thank you for response

> finishing that table and moving to another in the same database
Yes, that case. Vacuum processes relations in one database In cycle

сб, 31 окт. 2020 г. в 21:55, Jeff Janes <jeff.janes@gmail.com>:
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted
Next
From: PG Bug reporting form
Date:
Subject: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring