On Tue, 2018-11-27 at 10:20 +0530, Rohit Arora wrote: [is fighting canceled queries dur to replication conflicts, but fears primary bloat] In that case, I would set max_standby_streaming_delay = -1 max_standby_archive_delay = -1 hot_standby_feedback = off Then no queries should get canceled on the standby, and long queries on the standby won't cause bloat on the primary. The price you are paying is delayed replication. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
