Hi , The 'problem' was remedied to certain extent by increasing max_standby_streaming_delay=300000 # values in milliseconds I set it to 5 mins which is acceptable to our application.
regds Rajesh Kumar Mallah. On Thu, Oct 7, 2010 at 9:55 AM, Rajesh Kumar Mallah <mallah.raj...@gmail.com> wrote: > Dear List , > > We have setup primary/slave in HS & SR mode. We are diverting a part of > read only queries to the slave. > > The problem is that we are intermittently getting errors > ERROR: canceling statement due to conflict with recovery > on slave. We know that the tables which are participating in these queries > are not frequently updated ones. Can anyone suggest how can we > debug the situation. > > Regds > Rajesh Kumar Mallah. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
