On Fri, 25 Oct 2024, 14:36 James Pang, 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
> "transacti
You may find this helpful, the advice is not specific to RDS.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/wait-event.lw-lock-manager.html
HTH.
On Fri, 25 Oct 2024 at 18:36, Laurenz Albe wrote:
> On Fri, 2024-10-25 at 14:36 +0800, James Pang wrote:
> > we faced into a lot of lwlock:
On Fri, 2024-10-25 at 14:36 +0800, James Pang wrote:
> 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
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:LockMan
