Re: pg_visible_in_snapshot clarification

2023-08-31 Thread Luca Ferrari
On Mon, Aug 28, 2023 at 8:34 PM Mike Roest wrote: > I think this has to do with the pg_current_snapshot not showing the > transaction in the xip_list which appears to be empty on both C1 (in the > transaction) and C3 on the replica. However C2 pg_current_snapshot() does > show C1 xactid as in

pg_visible_in_snapshot clarification

2023-08-28 Thread Mike Roest
Hey There, I'm looking for some clarification around pg_visible_in_snapshot function. As it seems to not be working the way I would expect or the way the documentation is setup. I've attempted this on pg13 and pg15 and am getting the same behaviour. 3 connections via psql 2 to the primary and