Horton

lwlock:LockManager wait_events

James Pang <jamespang886@gmail.com>

View thread View on postgr.es
From: James Pang <jamespang886@gmail.com>
To: pgsql-performance@lists.postgresql.org
Date: 2024-10-25T06:36:26Z
Lists: pgsql-performance 
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 ?

Thanks,

James