Rohit Arora wrote: > I occasionally encounter below error. > > ERROR: canceling statement due to conflict with recovery > DETAIL: User was holding a relation lock for too long > > While investigating online i came to know that this issue can be handled by below configuration parameters > > "max_standby_archive_delay " > "max_standby_streaming_delay" > > I have increased the value of both the parameters as per below. > > Current values: > "max_standby_archive_delay=30s" ----> was increased it to 300s but we did not get any benefit so we rollback it to original value > "max_standby_streaming_delay=300s" > > But still i occasionally encounter the mention issue. You'd have to set max_standby_streaming_delay to -1 to avoid the error completely. But bear in mind that it can delay replication arbitrarily long. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
