Hot standby usage issue

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Hot standby usage issue
Date: 2010-10-07 04:25:59
Message-ID: AANLkTimf49w+eGgeiTQdZxQh7eQVi-_-AOWF7qQ-ghDj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2010-10-07 04:55:34 Re: Hot standby usage issue
Previous Message mark 2010-10-07 04:11:19 Re: Idle connections