Re: Fix possible overflow of pg_stat DSA's refcnt

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)datadoghq(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fix possible overflow of pg_stat DSA's refcnt
Date: 2024-06-27 00:48:26
Message-ID: Zny22nVJg9FW0qrE@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 26, 2024 at 08:48:06AM +0200, Anthonin Bonnefoy wrote:
> Yeah, this happened last week on one of our replicas (version 15.5)
> last week that had 134 days uptime. We are doing a lot of parallel
> queries on this cluster so the combination of high uptime plus
> parallel workers creation eventually triggered the issue.

It is not surprising that it would take this much amount of time
before detecting it. I've applied the patch down to 15. Thanks a lot
for the analysis and the patch!
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2024-06-27 01:35:27 Re: Add LSN <-> time conversion functionality
Previous Message David Rowley 2024-06-27 00:34:37 Re: Should we document how column DEFAULT expressions work?