Postgres Pro
Downloads
Home   >   mailing lists

Re: Apparently table locks are the key issue to see red flags - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Apparently table locks are the key issue to see red flags
Date
Msg-id CAHg7=h68+oRXAbmNznEJbuecC=Dyw4hMkZ21=KL=YxeB+kGv3g@mail.gmail.com
Whole thread Raw
In response to Apparently table locks are the key issue to see red flags  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-admin
Tree view
Need more detail on this.  Locks are generally caused by long updates or writes or perhaps a hung transaction. Can you reply with a bit more detail of what you are seeing, perhaps pg_stat_activity list?

Rule of thumb for high trx environments is to batch updates especially for larger tables to avoid excessive locking.

On Wed, Mar 16, 2022 at 4:32 PM Shaozhong SHI <shishaozhong@gmail.com> wrote:

Apparently table locks are the key issue to see red flags.

As we observe, every time, red marking occurs, there must be some tables are locked.

Can anyone shed light into this?

Regards,

David


--


Jayson Hreczuck | Principal Database Administrator

C: +1 617.571.9861130 Turner St, Ste 530, Waltham, MA 02453

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Shared postgres-cluster / permissions
Next
From: Laurenz Albe
Date:
Subject: Re: Shared postgres-cluster / permissions