-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 El 28/10/14 a las 15:37, Joe Van Dyk escibió: > On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo < > emanuel.calvo@xxxxxxxxxxxxxxx> 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? > Actually that means it will wait that the queries run forever. You should think which is your maximum threshold regarding query duration when conflicting with writes. - -- - -- Emanuel Calvo http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services Bs. As., Argentina (GMT-3) -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.18 (Darwin) Comment: GPGTools - http://gpgtools.org iQIcBAEBCgAGBQJUT+Z7AAoJEIBeI/HMagHmBjwQAKpLJBXzaeRy1zf/fOYR0sce joaIcyKXIJSwV9Eikc2LPbskfFVnZFoCdSfxL5/JmPNwBgramwinzoosDl/QbLwU sY1OvTbP7BBMiKGQyLR2zmqHtKBJ+BI92zLSay8qTjOWfZARakMH9CMNK+zqj2OZ ZTIBa5mtDsrmueWHchjtOx+hNsXfMKo1La2qPz3UIoAns1ti+ZtFDObP6kkYzhhL 4kpSxtHjksG0Rdp7drVs0LC2NgPl71Fy9BznNHAL53LGec1IniS4fkSQSo7XQKNc XZzq13VDLWFvyaNQ9eFlYujJlEwTKE3c7ygATjLodVAlz4UcY7mBXQOfAxUMKMsh EgjAfETdy2vE3qgSV0FcPnt/mdgcGjfBg6wqn/JhMuuk7MUovmu96vJ98Ksqm2sH yYx3bikaHUkE+OL0zfWUGYsIYuqMFTBmnEepvoXW/O6IeAv+b6qzTWtN4lP4K+s1 P5OI/SN/2shuAAvVr1Vhmc3cXYSWKIuu9c8MbTviULwiARl727m6oDU2vqiK8dGa KgdPsLHkiuxINouu86auE4fbeK68bYIM8fCK19meCLI50L0v1WLbfW+OKIvYnO8K tT3dE3yejjmWBj00UxQ2PD+3yeLySs6WJrGdYhzY9HtgWocrY3HLDtv5J8+ZB4ww EbYXrR2Yl5UKGjIlGfu+ =nIRk -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
