Re: Lock contention high

2021-10-12 Thread Mikhail Zhilin
Hi, How many sockets are on motherboard? What is CPU model and interconnect type (UPI?)? Can you share output of "lscpu"? If you have more than 1 NUMA node it may be worth to run PostgreSQL in single NUMA node via taskset. It will eliminate access to remote memory and speed up processing. Th

Re: Lock contention high

2021-10-14 Thread Mikhail Zhilin
e 64-127,192-255(Node1)   24: 18.3%  postgres  postgres    [.] LWLockAcquire   32: 7.06%  postgres  postgres    [.] LWLockAcquire I do not understand on interconnect type and has restrictions on lscpu . On Tuesday, October 12, 2021, Mikhail Zhilin <mailto:zhilin...@phystech.edu&