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