Hot standby usage issue - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Hot standby usage issue
Date
Msg-id AANLkTimf49w+eGgeiTQdZxQh7eQVi-_-AOWF7qQ-ghDj@mail.gmail.com
Whole thread Raw
Responses Re: Hot standby usage issue  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
Re: Hot standby usage issue  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "mark"
Date:
Subject: Re: Idle connections
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Hot standby usage issue