On Thu, May 12, 2016 at 6:37 AM, Viswanath <M.Viswanath16@xxxxxxxxx> wrote: > Hi, > I have the following configurations. > > On master: > autovacuum=off > vacuum_defer_cleanup_age=0 > > On slave: > hot_standby_feedback = off > max_standby_streaming_delay = 30s > > Now when I try to run a long query on slave and do some update or delete on > the table on master I am getting the following error. > > ERROR: canceling statement due to conflict with recovery > DETAIL: User query might have needed to see row versions that must be > removed. > > The error code was : 40001 > > I am not running vacuum manually and autovacuum is 'off' I hope you doing that for experimental purposes only. > What could possibly causing the conflict? Probably pruning of HOT update chains. Try turning hot_standby_feedback on, or setting vacuum_defer_cleanup_age to something more than zero. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
