Re: [PATCH] Fix minRecoveryPoint not advanced past checkpoint in CreateRestartPoint - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] Fix minRecoveryPoint not advanced past checkpoint in CreateRestartPoint
Date
Msg-id aii66Z4j3W2gm8K1@paquier.xyz
Whole thread
In response to Re: [PATCH] Fix minRecoveryPoint not advanced past checkpoint in CreateRestartPoint  (Nitin Jadhav <nitinjadhavpostgres@gmail.com>)
List pgsql-hackers
On Tue, Jun 09, 2026 at 06:08:36PM +0530, Nitin Jadhav wrote:
> Given that the current behavior creates inconsistency across
> recovery_target_action settings (pause and promote behave differently
> than shutdown), external tools such as pg_rewind, backup solutions,
> and monitoring systems depend on this value for operational decisions,
> I support moving forward with this patch.

FWIW, I am still unconvinced even after a second read of the thread.
In basically all workloads (hand-waving a number but let's say 99%),
we are going to have page flushes anyway between a CHECKPOINT record
replayed and the recovery target, where each one is going to naturally
update the minRecoveryPoint.  I'd still want less paths that update
minRecoveryPoint at the end of the day, not more of them.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Enrique Sánchez
Date:
Subject: Re: Extended statistics improvement: multi-column MCV missing values
Next
From: Michael Paquier
Date:
Subject: Re: Fix DROP PROPERTY GRAPH "unsupported object class" error