medium10 pts · first answer countsreplicationpostgresql

Reports cancelled on the replica

Long reports on a hot standby fail with "canceling statement due to conflict with recovery". What is happening?

A.The standby ran out of disk spaceB.The report used too much work_memC.Replayed changes, such as vacuum removing old rows, conflict with rows the report still needs, so the standby cancels itD.The primary is down and the standby is promoting

← Measuring replica lag Is pg_dump consistent? →