Re: How to check for in-progress transactions

2023-03-16 Thread Tejasvi Kashi
On Thu, Mar 16, 2023 at 17:01, Melanie Plageman wrote: > On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi 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. > >

Re: How to check for in-progress transactions

2023-03-16 Thread Melanie Plageman
On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi 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/

Re: How to check for in-progress transactions

2023-03-16 Thread Tejasvi Kashi
Hi Bharath, 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. Sincerely, Tej Kashi MMath CS, University of Waterloo Waterloo, ON, CA On Thu, 16 Mar 2023 at 01:36, Bharath

Re: How to check for in-progress transactions

2023-03-15 Thread Bharath Rupireddy
On Thu, Mar 16, 2023 at 1:18 AM Tejasvi Kashi wrote: > > For my use case, I'm trying to ascertain if there are any in-flight > transactions that are yet to be replicated to synchronous standbys (in a > synchronous streaming replication setting) > > I've been looking at sent_lsn, write_lsn, flush