Re: Dead lock after the migration from CentOS 7 to RHEL 9

To: Wasim Devale <wasimd60@xxxxxxxxx>
Subject: Re: Dead lock after the migration from CentOS 7 to RHEL 9
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 14 Aug 2024 20:31:16 -0700
Cc: Muhammad Waqas <waqas.m@xxxxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CAB5fag7hsyWJUv=KezM=10RZ8hs=3fDkR4vMmJvn-Fjv3O0oeA@mail.gmail.com>
References: <CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com> <CAB5fag6QPm1OE7H6roywzovDxb9rT9Wx-MdeiuK=mDvx6NTwtw@mail.gmail.com> <CAKFQuwbHt_56dOP-Fjtaj2C9KVJN14-L9LrDUf5AeWyW21g7KQ@mail.gmail.com> <CAB5fag7hsyWJUv=KezM=10RZ8hs=3fDkR4vMmJvn-Fjv3O0oeA@mail.gmail.com>

On Wednesday, August 14, 2024, Wasim Devale <wasimd60@xxxxxxxxx> wrote:

So it's not a postgresql issue. It's from the application side correct?

That’s the assumption. The vast majority of locks happen because the “application” executed SQL commands.

David J.

Follow-Ups:
- Re: Dead lock after the migration from CentOS 7 to RHEL 9
  - From: Wasim Devale

References:
- Dead lock after the migration from CentOS 7 to RHEL 9
  - From: Wasim Devale
- Fwd: Dead lock after the migration from CentOS 7 to RHEL 9
  - From: Wasim Devale
- Re: Dead lock after the migration from CentOS 7 to RHEL 9
  - From: David G. Johnston
- Re: Dead lock after the migration from CentOS 7 to RHEL 9
  - From: Wasim Devale