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