Re: Persist slot invalidations before publishing them

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, JoongHyuk Shin <sjh910805(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Rui Zhao <zhaorui126(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Persist slot invalidations before publishing them
Date: 2026-10-09 06:03:20
Message-ID: asiDqJiU0Sna4nFl@bdtpg
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Wed, Oct 07, 2026 at 09:33:24AM +0530, shveta malik wrote:
> On Tue, Oct 6, 2026 at 1:03 PM Bertrand Drouvot
> <bertranddrouvot(dot)pg(at)gmail(dot)com> wrote:
> >
> > I looked at it, but I think that it makes ordinary save errors get reported while
> > holding io_in_progress_lock. In particular, the LOG path would perform logging
> > and check for interrupts before releasing the lock.
>
> I considered this when posting the comment, but then thought that the
> other flow, 'SaveInvalidatedSlotToPath' is no different and has the
> same limitations. Thus, I thought it should be okay if both flows
> share the same logic (and limitations too).
> But on re-thinking, I think you are worried about the flow from
> CheckPointReplicationSlots() which only logs issues instead of
> erroring out. I see your point now.

Yeah that's the case I had in mind.

> > As this is meant to be backpatched, I'm not sure it's worth changing the existing
> > behavior as part of this fix. The proposed cleanup could be considered separately
> > on HEAD as a follow up patch though.
> >
> > What do you think?
> >
>
> Okay, works for me.

PFA a mandatory rebase due to conflicts in test/recovery/meson.build.

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v10-0001-Persist-slot-invalidations-before-publishing-the.patch text/x-diff 29.5 KB
v10-0002-Persist-synchronized-slot-invalidations-before-p.patch text/x-diff 8.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-10-09 06:05:00 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces
Previous Message Andrey Borodin 2026-10-09 06:02:37 Re: Do we want to solve reload/config races more generally? (was: Postmaster crashes on SIGHUP when oauth_validator_libraries holds only whitespace)