| From: | "Mike Klaas" <mike(at)superhuman(dot)com> |
|---|---|
| To: | "Thomas Munro" <thomas(dot)munro(at)gmail(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 02:22:52 |
| Message-ID: | kahktz8f.364db8ff-1a69-4e30-9be0-d42e1f1767b7@we.are.superhuman.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 21, 2020 at 5:19 PM, Thomas Munro < thomas(dot)munro(at)gmail(dot)com > wrote:
>
>
>
> On Fri, May 22, 2020 at 7:48 AM Mike Klaas < mike@ superhuman. com (
> mike(at)superhuman(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2020-05-22 05:28:21 | Re: Query returns no rows in pg_basebackup cluster |
| Previous Message | Thomas Munro | 2020-05-22 00:19:37 | Re: Help understanding SIReadLock growing without bound on completed transaction |