Postgres Pro
Downloads
Home   >   mailing lists

Problems with Multixacts LWLocks - Mailing list pgsql-performance

From Czarek
Subject Problems with Multixacts LWLocks
Date
Msg-id OajTzsuYhm-LUQDPPn_2uujez2BKe_A-d7O65jNqjBafGFI3-2poTR6z7MPvlyryYWjE0OIvyqCw29b9QA526CU3SP5QgXGAGCeHy-6LNYk=@protonmail.com
Whole thread Raw
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Julian Wolf
Date:
Subject: Re: Too few rows expected by Planner on partitioned tables
Next
From: Burhan Akbulut
Date:
Subject: Hstore index for full text search