Re: Help understanding SIReadLock growing without bound on completed transaction

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Mike Klaas <mike(at)superhuman(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, Engineering-archive <engineering-archive(at)superhuman(dot)com>
Subject: Re: Help understanding SIReadLock growing without bound on completed transaction
Date: 2020-05-22 00:19:37
Message-ID: CA+hUKGJ76CEABZoj4uf-Ng3S-O11EkmxAZ1UgNiHFoKq=Hvm8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 22, 2020 at 7:48 AM Mike Klaas <mike(at)superhuman(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Klaas 2020-05-22 02:22:52 Re: Help understanding SIReadLock growing without bound on completed transaction
Previous Message Tim Cross 2020-05-21 23:48:59 Re: Should I use JSON?