On Tue, Sep 8, 2020 at 6:15 PM Tom Lane wrote:
Well, we don't know what isolation level the OP is using.
We use the default. We do not explicitly set the isolation level.
We also don't know what PG version he's using.
it's 12.1
From memory, it hasn't been that longThere are no open cursors.
since we fixed things so that an idle read-committed transaction
advertises no xmin. It's also possible that the transaction isn't really
idle between statements (eg, if it's holding open cursors, or the like).
--
Regards,
Michael Holzman
Michael Holzman
