Horton

Re: Allow reading LSN written by walreciever, but not flushed yet

Andrey Borodin <x4mmm@yandex-team.ru>

View thread
From: Andrey Borodin <x4mmm@yandex-team.ru>
To: Jeremy Schneider <schneider@ardentperf.com>
Cc: Fujii Masao <masao.fujii@oss.nttdata.com>, Amit Kapila <amit.kapila16@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2025-10-06T09:05:31Z
Lists: pgsql-hackers 

> On 6 Oct 2025, at 04:42, Jeremy Schneider <schneider@ardentperf.com> wrote:
> 
> A large and stressed system could get into a state where fsync takes
> awhile. 

For such cases I would like to have a function that ensures walreceiver will not acknowledge any new LSN. And then returns last ack'ed LSN.

Today we have to stop walreceiver, which takes some time from our 9999s.


Best regards, Andrey Borodin.