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<http://aka.ms/weboutlook>

Reply via email to