Re: How to check for in-progress transactions - Mailing list pgsql-hackers

From Tejasvi Kashi
Subject Re: How to check for in-progress transactions
Date
Msg-id CAJWWkaqsrBjz9Nc42ponaYQCBK-HsO8s2=UNjSdwBsp4fYk2mQ@mail.gmail.com
Whole thread Raw
In response to Re: How to check for in-progress transactions  (Melanie Plageman <melanieplageman@gmail.com>)
List pgsql-hackers
On Thu, Mar 16, 2023 at 17:01, Melanie Plageman <melanieplageman@gmail.com> wrote:
On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi <mail@tejasvi.dev> wrote:
> Thanks a lot for your reply. It looks like this is exactly what I need. For my use case, I'm trying to get read-only transactions to wait for the replication of prior writes.

can't you use remote_apply?

https://www.postgresql.org/docs/15/runtime-config-wal.html

That will ensure that the writes are acknowledged only after remote application. But, in my case, I’m trying to get read transactions to wait if they have seen a write that is yet to be replicated. 


pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: How to check for in-progress transactions
Next
From: Justin Pryzby
Date:
Subject: Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF