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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
