Re: lwlock:LockManager wait_events

Поиск
Список
Период
Сортировка
От SAMEER KUMAR
Тема Re: lwlock:LockManager wait_events
Дата
Msg-id CAGPeHmiuURaY4K=Kj6uktbiKBt-cGPFpH-2Vvb90ZgnB0TAXwA@mail.gmail.com
обсуждение исходный текст
Ответ на lwlock:LockManager wait_events  (James Pang <jamespang886@gmail.com>)
Ответы Re: lwlock:LockManager wait_events
Список pgsql-performance
Дерево обсуждения


On Fri, 25 Oct 2024, 14:36 James Pang, <jamespang886@gmail.com> wrote:
experts,
    we faced into a lot of  lwlock:LockManager wait-events , all of these queries are "select ..." ,  there are other several session are doing DML, insert/update/delete on same table.   Did these DML transactions holding "transactionid" and "tuple" lock blocking "select" on lwlock:LockManager ?  


Which version of PostgreSQL?
Are these all same query or variant of same query (with different parameters)? 

What's the schema (you can redact column names) for the tables involved in the select query which is blocked/waiting on lock_manager? 


Thanks,

James

В списке pgsql-performance по дате отправления: