Postgres Pro
Downloads
Home   >   mailing lists

Re: Help understanding SIReadLock growing without bound on completed transaction - Mailing list pgsql-general

From Thomas Munro
Subject Re: Help understanding SIReadLock growing without bound on completed transaction
Date
Msg-id CA+hUKGJ76CEABZoj4uf-Ng3S-O11EkmxAZ1UgNiHFoKq=Hvm8w@mail.gmail.com
Whole thread Raw
In response to Help understanding SIReadLock growing without bound on completedtransaction  ("Mike Klaas" <mike@superhuman.com>)
Responses Re: Help understanding SIReadLock growing without bound oncompleted transaction
List pgsql-general
Tree view 
On Fri, May 22, 2020 at 7:48 AM Mike Klaas <mike@superhuman.com> wrote:
> locktype: page
> relation::regclass::text: <table>_pkey
> virtualtransaction: 36/296299968
> granted:t
> pid:2263461

That's an unusually high looking pid.  Is that expected, for example
did you crank Linux's pid_max right up, or is this AIX, or something?

pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: Should I use JSON?
Next
From: "Mike Klaas"
Date:
Subject: Re: Help understanding SIReadLock growing without bound oncompleted transaction