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
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