Re: How to check for in-progress transactions

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Tejasvi Kashi <mail(at)tejasvi(dot)dev>
Cc: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: How to check for in-progress transactions
Date: 2023-03-16 21:01:23
Message-ID: CAAKRu_a-_dk-TyhFLqB+__WnVTGsG0HRSgGFcnn4tY19aojeZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi <mail(at)tejasvi(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tejasvi Kashi 2023-03-16 21:08:17 Re: How to check for in-progress transactions
Previous Message Tom Lane 2023-03-16 20:52:07 Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF