Nikhil Shetty <nikhil.dba04@xxxxxxxxx> writes: > 2022-06-12 04:30:01 UTC [3324]: [3-1] > user=<user>,db=postgres,app=<app>,client=127.0.0.1ERROR: canceling > statement due to *conflict with recovery* > 04:30:01 UTC [3324]: [4-1] > user=<user>,db=postgres,app=<app>,client=127.0.0.1DETAIL: User was holding > shared buffer pin for too long. > We have set below parameters in standby > hot_standby_feedback = on > max_standby_streaming_delay = 0 > How can we avoid this error on standby? Use a larger max_standby_streaming_delay. Setting it to zero means precisely that conflicting queries will be canceled immediately. regards, tom lane
