Tracking commit LSNs of tuple xmins for read txns

2023-06-05 Thread Tejasvi Kashi
Hi everyone, When a transaction reads tuples from the heap, I would like to keep track of the maximum commit LSN of the xmin transactions of tuples as they are read. For e.g., consider a transaction T that reads tuples [t1, t2, t3] with respective xmins [700, 705, 702] and respective commit LSNs [

Re: SyncRepWaitForLSN waits for XLogFlush?

2023-05-24 Thread Tejasvi Kashi
ing on modifying the transaction manager for my thesis project, and the pg_walinspect test is failing when I run make check-world. So, I'm just trying to understand things to identify the cause of this issue. Regards, Tej On Wed, 24 May 2023 at 17:33, Andres Freund wrote: > Hi, > > On 2023-0

SyncRepWaitForLSN waits for XLogFlush?

2023-05-24 Thread Tejasvi Kashi
Hi everyone, I was wondering if waiting for an LSN in SyncRepWaitForLSN ensures that the XLOG has been flushed locally up to that location before the record is shipped off to standbys? Regards, Tej

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 > replica

Re: How to check for in-progress transactions

2023-03-16 Thread Tejasvi Kashi
01:36, Bharath Rupireddy < bharath.rupireddyforpostg...@gmail.com> wrote: > 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 stan

How to check for in-progress transactions

2023-03-15 Thread Tejasvi Kashi
Hi everyone, I'm Tej, a grad student poking around postgres for a project. 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) The first way to do this would be to