On Thu, May 12, 2016 at 9:22 PM, Viswanath <M(dot)Viswanath16(at)gmail(dot)com> wrote:
> Hi,
> Thank you for the explanation.
> The slave queries are mostly reporting queries,which sometimes would take
> 30+ running time due to complex joins and criteria. We haven't tried running
> these queries on master before splitting, and it is possible that there will
> be heavy updates and deletes on master on some tables some times. Now we
> have to decide between these two parameters as which one to use. Can you
> give any suggestion?
I would go with hot_standby_feedback = on, and look for other
solutions only if that is demonstrated to cause a problem (like severe
bloat) under your workload.
Cheers,
Jeff