cks climbing when it hits a problematic item,
while the number of active transactions (of course) stays low.
Mike
On Fri, Apr 30, 2021 at 4:53 PM Mike Beachy wrote:
>
> On Fri, Apr 30, 2021 at 7:12 AM Thomas Munro wrote:
> > But do you have lots of short overlapping transactions so t
On Fri, Apr 30, 2021 at 7:12 AM Thomas Munro wrote:
> But do you have lots of short overlapping transactions so that there
> is never a moment where there are zero transactions running?
Yeah, that almost certainly explains it.
Thanks very much for the explanation about the summarized locks.
> T
Hi Laurenz -
On Tue, Apr 27, 2021 at 2:56 AM Laurenz Albe
wrote:
> Not sure, but do you see prepared transactions in "pg_prepared_xacts"?
>
No, the -1 in the virtualtransaction (
https://www.postgresql.org/docs/11/view-pg-locks.html) for
pg_prepared_xacts was another clue I saw! But, it seems m
On Mon, Apr 26, 2021 at 6:16 PM Tom Lane wrote:
> Hmm, that's an invalid VXID, which would ordinarily mean that nothing
> is holding the lock. There is a passing mention in mvcc.sgml that
> SIRead locks sometimes need to be held past transaction end, so maybe
> what you're looking at is such a l
Hi -
Does anyone have any pointers on what a virtualtransaction of '-1/0' means?
I'm using SSI and an example is
locktype | database | relation | page | tuple | virtualxid |
transactionid | classid | objid | objsubid | virtualtransaction | pid |
mode| granted | fastpath
--+-
