Logical replication from multiple masters - master starvation

Поиск
Список
Период
Сортировка
От Dan shmidt
Тема Logical replication from multiple masters - master starvation
Дата
Msg-id MN2PR02MB644766952475759D0A3211F5A44A0@MN2PR02MB6447.namprd02.prod.outlook.com
обсуждение исходный текст
Список pgsql-general
Hi everyone,

I'm using postgres 11.4
I have a configuration in which there's one subscriber (slave) node which subscribes to several (4) publisher nodes (master).
I noticed one of the master servers keeps lagging behind. I noticed that the replication worker on the master keeps failing on timeouts. 
When querying pg_stat_subscription on the slave I noticed that last_msg_send_time for this master hardly ever updates. 

Could this be starvation? 
Is there any special configuration on either side (master/slave) that can help reduce that?
What's the logic on the slave that chooses from which subscription to process incoming data?
How can I further debug this?

Thanks,
Dan.

Sent from Outlook

В списке pgsql-general по дате отправления:

Предыдущее
От: Raj Gandhi
Дата:
Сообщение: Postgres 12 - default value for text column
Следующее
От: David Rowley
Дата:
Сообщение: Re: Postgres 12 - default value for text column