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
