From: | Max Vikharev <bm(dot)kinder(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #16691: Autovacuum stops processing certain databases until postgresql rebooted |
Date: | 2020-11-01 06:18:43 |
Message-ID: | CACRpr1NLVbQ9o+Kv=R-CzO9fgtZAjKVoMHdmfPDoMrkDJYsyrA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)janes(at)gmail(dot)com>:
> On Thu, Oct 29, 2020 at 5:44 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16691
>> Logged by: Max Vikharev
>> Email address: bm(dot)kinder(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2020-11-01 16:51:56 | BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring |
Previous Message | Tom Lane | 2020-10-31 23:57:23 | Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch |