Postgres Pro
Downloads
Home   >   mailing lists

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

From Mike Klaas
Subject Re: Help understanding SIReadLock growing without bound oncompleted transaction
Date
Msg-id kahktz8f.364db8ff-1a69-4e30-9be0-d42e1f1767b7@we.are.superhuman.com
Whole thread Raw
In response to Re: Help understanding SIReadLock growing without bound on completed transaction  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
Tree view

On Thu, May 21, 2020 at 5:19 PM, Thomas Munro <thomas.munro@gmail.com> wrote:

On Fri, May 22, 2020 at 7:48 AM Mike Klaas <mike@superhuman.com> wrote:

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?


Unfortunately I'm not sure exactly what it's running on as it's a cloud-provided database instance running on google cloud:

=> select version();

PostgreSQL 9.6.16 on x86_64-pc-linux-gnu, compiled by clang version 7.0.0-3~ubuntu0.18.04.1 (tags/RELEASE_700/final), 64-bit


-Mike

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Help understanding SIReadLock growing without bound on completed transaction
Next
From: "Andrus"
Date:
Subject: Re: Query returns no rows in pg_basebackup cluster