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