From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | HORDER Philip <Phil(dot)Horder(at)uk(dot)thalesgroup(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Restore of a reference database kills the auto analyze processing. |
Date: | 2024-05-22 16:05:24 |
Message-ID: | 49a5340c-7eb6-4063-8fad-ea15444c598e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/22/24 08:55, HORDER Philip wrote:
> Classified as: {OPEN}
>
>> https://www.postgresql.org/docs/15/release-15-5.html#id-1.11.6.7.4
>
>> Fix race condition in database dropping that could lead to the autovacuum launcher getting stuck
>
> Wow, that sounds like our problem!
Another thought I had is that since you are on Windows maybe there is an
AV program seeing the autovacuum as virus-like and killing it. Though I
would expect there to be more errors in that case. Anyway it might be
worth investigating should an upgrade not fix it.
>
> I will investigate. Maybe try and find the orphaned stats entry to prove it.
It would be a good idea to upgrade to 15.7 in any case to get all the
other bug/security fixes.
>
> Phil Horder
> Database Mechanic
>
> Thales
> Land & Air Systems
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Isaac Morland | 2024-05-22 16:13:12 | Re: Finding "most recent" using daterange |
Previous Message | Keith Fiske | 2024-05-22 15:57:40 | Re: Regarding use case of epoch to generate nanoseconds precision |