lwlock:LockManager wait_events

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: lwlock:LockManager wait_events
Date: 2024-10-25 06:36:26
Message-ID: CAHgTRfesRFm1BuG_5guvdSCof2qoHGZvaa1YEkim97EMALaWgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2024-10-25 07:36:45 Re: lwlock:LockManager wait_events
Previous Message Pavel Stehule 2024-10-25 05:21:34 Re: proposal: schema variables