Thread: Hot standby usage issue

Hot standby usage issue

From
Rajesh Kumar Mallah
Date:
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.

Re: Hot standby usage issue

From
Rajesh Kumar Mallah
Date:
both servers are on same gigabit switch.

Re: Hot standby usage issue

From
Rajesh Kumar Mallah
Date:
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.rajesh@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.
>