Postgres Pro
Downloads
Home   >   mailing lists

MultiXactMemberControlLock contention on a replica - Mailing list pgsql-general

From Christophe Pettus
Subject MultiXactMemberControlLock contention on a replica
Date
Msg-id 76AD9A74-E518-4D2F-A4B7-EBB6203530C3@thebuild.com
Whole thread Raw
Responses Re: MultiXactMemberControlLock contention on a replica  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
On a whole fleet of load-balanced replicas, we saw an incident where one particular query started backing up on
MultiXactMemberControlLockand multixact_member.  There was no sign of this backup on the primary.  Under what
conditionswould there be enough multixact members on a replica (where you can't do UPDATE / SELECT FOR UPDATE / FOR
SHARE)to start spilling to disk? 
--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: Karthik Kumar Kondamudi
Date:
Subject: Insert into on conflict, data size upto 3 billion records
Next
From: Noah Bergbauer
Date:
Subject: Re: Preventing free space from being reused