Re: LWLock optimization

2019-07-23 Thread Andres Freund
Hi, On 2019-07-23 16:28:52 +, Alexander Pyhalov wrote: > I was asked to bring up this topic on maling lists after asking question on > IRC. > > The issue is the following. > On one of our servers (10.5), I see a lot of queries with > wait_event_type='LWLock', wait_event='lock_manager' Co

LWLock optimization

2019-07-23 Thread Alexander Pyhalov
Hi. I was asked to bring up this topic on maling lists after asking question on IRC. The issue is the following. On one of our servers (10.5), I see a lot of queries with wait_event_type='LWLock', wait_event='lock_manager' This is a stat gathering/analyzing application with tables which have