Re: Improve WAIT FOR read-your-writes consistency doc

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Sami Imseih <samimseih(dot)pg(at)gmail(dot)com>
Cc: Xuneng Zhou <xunengzhou(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Improve WAIT FOR read-your-writes consistency doc
Date: 2026-09-16 22:30:27
Message-ID: CAPpHfduds=5upQGq6zssKCYXFdm7f=QEQQBHQPSV30X=jNLT0Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 15, 2026 at 4:27 PM Sami Imseih <samimseih(dot)pg(at)gmail(dot)com> wrote:
> Attached is a rebase.

I've made this following changes to the patch.
1) Change <command>WAIT FOR</command> back to <command>WAIT</command>
(see a23ab4862cfe).
2) In the example, app gets lsn at or after *the end* of the relevant
write transaction's COMMIT record. If we say lsn at the COMMIT record
then it might be interpreted as at he beginning of that record (and
that is wrong).

I'm going to push this if no objections.

------
Regards,
Alexander Korotkov
Supabase

Attachment Content-Type Size
v4-0001-doc-Say-which-LSN-gives-read-your-writes-with-WAI.patch application/octet-stream 5.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2026-09-16 22:41:32 Re: [PATCH] Explain what the default output_plugin_libraries do
Previous Message Alexandre Felipe 2026-09-16 22:06:34 BUG #19686: Rolling back SET TABLESPACE