MultiXactMemberControlLock contention on a replica

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема MultiXactMemberControlLock contention on a replica
Дата
Msg-id 76AD9A74-E518-4D2F-A4B7-EBB6203530C3@thebuild.com
обсуждение исходный текст
Ответы Re: MultiXactMemberControlLock contention on a replica  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Karthik Kumar Kondamudi
Дата:
Сообщение: Insert into on conflict, data size upto 3 billion records
Следующее
От: Noah Bergbauer
Дата:
Сообщение: Re: Preventing free space from being reused