Conflict between recovery thread and client queries on a hot standby replica

Hi It seems that the recovery thread(streaming replication) and sql queries against a postgresql hot standby can produce a deadlock. If you have conflicting statements running on master and slave, you can end up with queries on the slave waiting for locks of the recovery thread and the recov

Conflict between recovery thread and client queries on a hot standby replica

Hi It seems that the recovery thread(streaming replication) and sql queries against a postgresql hot standby can produce a deadlock. If you have conflicting statements running on master and slave, you can end up with queries on the slave waiting for locks of the recovery thread and the recov