Re: some queries on standby preventing replication updates

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

--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services