Re: Apparently table locks are the key issue to see red flags

Поиск
Список
Период
Сортировка
От Jayson Hreczuck
Тема Re: Apparently table locks are the key issue to see red flags
Дата
Msg-id CAHg7=h68+oRXAbmNznEJbuecC=Dyw4hMkZ21=KL=YxeB+kGv3g@mail.gmail.com
обсуждение исходный текст
Ответ на Apparently table locks are the key issue to see red flags  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: Shared postgres-cluster / permissions
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Shared postgres-cluster / permissions