Re: some queries on standby preventing replication updates

Joe Van Dyk wrote
> On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo <

> emanuel.calvo@

>> wrote:
>
>>
>> El 23/10/14 a las 17:40, Joe Van Dyk escibió:
>> > Hi,
>> >
>> > I have a master and a slave database.
>> >
>> > I've got hot_standby_feedback turned on,
>> > max_standby_streaming_delay=-1. I've configured the master and slave
>> > to keep a few days of WALs around.
>> >
>> > I've noticed that when some large queries are run on the standby
>> > machine (ones that take more than a minute or so), replication updates
>> > are paused. Is there a way to fix this?
>> >
>> You may need to set a value on max_standby_streaming_delay, which
>> controls the time
>> before cancelling the standby queries when a conflict occurs on a
>> wal-records-about-to-be-applied.
>>
>> Source:
>> http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html
>
> I'm using -1 for that option, would using something different be better?

Why did you choose -1?

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/some-queries-on-standby-preventing-replication-updates-tp5824090p5824675.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.