Schedule - PGDay/MED 2023
Recovery conflicts in PostgreSQL - understanding error "canceling statement due to conflict with recovery"
Feedback: Leave feedback
Recovery conflicts is a very common problem with customers when they are using physical replication and are also running queries on the replica. In this session I will explain the different reasons which can cause the recovery conflicts listed here : https://github.com/postgres/postgres/blob/master/src/backend/tcop/postgres.c#L2459
The talk will also explain how to monitor and deal with/avoid these conflicts on the standby.