| Lists: | pgsql-general |
|---|
| 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 |
| 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.
| From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Hot standby usage issue |
| Date: | 2010-10-07 04:55:34 |
| Message-ID: | AANLkTinPUT1yskL8a_eNk-W4WjBaHjyyrfT=JoOJb8v7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
both servers are on same gigabit switch.
| From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Hot standby usage issue |
| Date: | 2010-10-07 11:04:59 |
| Message-ID: | AANLkTikPKiMB-w_v8Xj2okMHv-Qaaq-OKTsrPQrJsj3u@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(dot)rajesh(at)gmail(dot)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.
>