Re: Implement waiting for wal lsn replay: reloaded

Alexander Korotkov <aekorotkov@gmail.com>

From: Alexander Korotkov <aekorotkov@gmail.com>

To: Xuneng Zhou <xunengzhou@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>, Michael Paquier <michael@paquier.xyz>, jian he <jian.universality@gmail.com>, Tomas Vondra <tomas@vondra.me>, Yura Sokolov <y.sokolov@postgrespro.ru>, Álvaro Herrera <alvherre@kurilemu.de>

Date: 2025-11-03T11:46:40Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Clean up 019_replslot_limit.pl comments
- 0b866bb90368 19 (unreleased) landed
Stabilize 019_replslot_limit.pl: wait on slot restart_lsn
- cdb1d1cf1de6 19 (unreleased) landed
Use WAIT FOR LSN in PostgreSQL::Test::Cluster::wait_for_catchup()
- 7e8aeb9e483d 19 (unreleased) landed
- f30848cb05d4 19 (unreleased) landed
Add tab completion for the WAIT FOR LSN MODE option
- 76948337f724 19 (unreleased) landed
Add the MODE option to the WAIT FOR LSN command
- 49a181b5d634 19 (unreleased) landed
Extend xlogwait infrastructure with write and flush wait types
- 7a39f43d885b 19 (unreleased) landed
Unify error messages
- 502e256f2262 19 (unreleased) cited
Optimize shared memory usage for WaitLSNProcInfo
- 75e82b2f5a6f 19 (unreleased) landed
Fix WaitLSNWakeup() fast-path check for InvalidXLogRecPtr
- ede6acef4967 19 (unreleased) landed
Fix incorrect function name in comments
- 23792d738158 19 (unreleased) landed
Add infrastructure for efficient LSN waiting
- 3b4e53a075ea 19 (unreleased) landed
Add pairingheap_initialize() for shared memory usage
- 8af3ae0d4b36 19 (unreleased) landed
Implement WAIT FOR command
- 447aae13b030 19 (unreleased) landed

Attachments

v20-0002-Add-infrastructure-for-efficient-LSN-waiting.patch (application/octet-stream) patch v20-0002
v20-0001-Add-pairingheap_initialize-for-shared-memory-usa.patch (application/octet-stream) patch v20-0001
v20-0003-Implement-WAIT-FOR-command.patch (application/octet-stream) patch v20-0003

Hello, Xuneng!

On Mon, Nov 3, 2025 at 4:20 AM Xuneng Zhou <xunengzhou@gmail.com> wrote:
> On Sun, Nov 2, 2025 at 2:24 PM Xuneng Zhou <xunengzhou@gmail.com> wrote:
> > On Thu, Oct 23, 2025 at 8:58 PM Xuneng Zhou <xunengzhou@gmail.com> wrote:
> > I’ve made a few minor updates to the comments and docs in patches 2
> > and 3. The patch set LGTM now.
>
> Fix an minor issue in v18: WaitStmt was mistakenly added to
> pgindent/typedefs.list in patch 2, but it should belong to patch 3.

Thank you.  I also made some minor changes to 0002 renaming
"operation" => "lsnType".

I'd like to give this subject another chance for pg19.  I'm going to
push this if no objections.

------
Regards,
Alexander Korotkov
Supabase