On Thu, May 12, 2016 at 9:22 PM, Viswanath <M.Viswanath16@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
