Re: lwlock:LockManager wait_events
| От | kyle Hailey |
|---|---|
| Тема | Re: lwlock:LockManager wait_events |
| Дата | |
| Msg-id | CADsdiQjTrkn8RNSu-exzRynyEt9N_1yAjw9L8nXSGDVS5QRuRA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: lwlock:LockManager wait_events (SAMEER KUMAR <sameer.kasi200x@gmail.com>) |
| Список | pgsql-performance |
late to the game here but this might be of interest:
On Fri, Oct 25, 2024 at 5:10 AM SAMEER KUMAR <sameer.kasi200x@gmail.com> wrote:
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 по дате отправления: