Re: Need help identifying a periodic performance issue.

2021-11-29 Thread Robert Creager
> On Nov 24, 2021, at 4:15 PM, Justin Pryzby wrote: > > This message originated outside your organization. > > On Wed, Nov 24, 2021 at 10:44:12PM +, Robert Creager wrote: >> I forgot, I had reloaded postgres, but had not re-started our app, so the >> connections wouldn’t have that plan sett

Re: Lock contention high

2021-11-29 Thread arjun shetty
1. How to check which NUMA node in PostgreSQL process fetching from the memory? 2. Is NUMA configuration is better for PostgreSQL? vm.zone_reclaim_mode= 0 numactl --interleave = all /init.d/ PostgreSQL start kernel.numa_balancing= 0 On Wednesday, November 17, 2021, arjun