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 <sameer.kasi2...@gmail.com> wrote: > > > On Fri, 25 Oct 2024, 14:36 James Pang, <jamespang...@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 >> >
