Re: LWlock:LockManager waits

2024-04-08 Thread Laurenz Albe
On Tue, 2024-04-09 at 11:07 +0800, James Pang wrote: >    we found sometimes , with many sessions running same query "select ..." at > the same time, saw many sessions waiting on "LockManager".  for example, > pg_stat_activity show.  It's a production server, so no enable trace_lwlocks > flag. c

LWlock:LockManager waits

2024-04-08 Thread James Pang
we found sometimes , with many sessions running same query "select ..." at the same time, saw many sessions waiting on "LockManager". for example, pg_stat_activity show. It's a production server, so no enable trace_lwlocks flag. could you direct me what's the possible reason and how to reduce