Problems with Multixacts LWLocks

Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Problems with Multixacts LWLocks

Czarek
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