Hi,
I have problem with my Postgres production server.
Sometimes there a lot of Multiexact* LWlocks:
MultiXactOffsetControlLock
MultiXactMemberControlLock
that significantly impact on users queries performance.
How to find what is the reason of Multiexact* LWlocks?
Hardware:
110 CPU
620 GB RAM
CentOS 7.4.1708
kernel 3.10.0-693.5.2.el7.x86_64
Database:
size 4,5 TB
server_version 9.6
checkpoint_timeout 1800 s
effective_cache_size 449280 MB
maintenance_work_mem 4096 MB
max_connections 440
shared_buffers 149760 MB
work_mem 190 MB
Any ideas?
Best regards