late to the game here but this might be of interest:
https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/
On Fri, Oct 25, 2024 at 5:10 AM SAMEER KUMAR
wrote:
>
>
> On Fri, 25 Oct 2024, 14:36 James Pang, wrote:
>
>> experts,
>> we faced into
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
