Re: Hot Standby query cancellation and Streaming Replication integration - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Hot Standby query cancellation and Streaming Replication integration
Date
Msg-id 201002262220.o1QMKbD00176@momjian.us
Whole thread Raw
In response to Re: Hot Standby query cancellation and Streaming Replication integration  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
Dimitri Fontaine wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Doesn't the system already adjust the delay based on the length of slave
> > transactions, e.g. max_standby_delay.  It seems there is no need for a
> > user switch --- just max_standby_delay really high.
> 
> Well that GUC looks like it allows to set a compromise between HA and
> reporting, not to say "do not ever give the priority to the replay while
> I'm running my reports". At least that's how I understand it.

Well, if you set it high, it effectively is that.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.comPG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard
drive,Christ can be your backup. +
 


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Robert Haas
Date:
Subject: Re: Avoiding bad prepared-statement plans.