We're running into issues with canceled queries on a standby server and have be debating between enabling hot_standby_feedback and setting max_standby_streaming_delay to something large.
Using max_standby_streaming_delay seems to have the advantage of keeping the master independent of the standby, but will a long running query mean that all WAL commits are delayed? Or just those that affected by the long running query?
Thanks,Using max_standby_streaming_delay seems to have the advantage of keeping the master independent of the standby, but will a long running query mean that all WAL commits are delayed? Or just those that affected by the long running query?
