Re: [GENERAL] some queries on standby preventing replication updates

2014-10-28 Thread Torsten Förtsch
On 28/10/14 19:37, Joe Van Dyk wrote: > On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo > mailto:emanuel.ca...@2ndquadrant.com>> > 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_f

Re: [GENERAL] some queries on standby preventing replication updates

2014-10-28 Thread David G Johnston
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

Re: [GENERAL] some queries on standby preventing replication updates

2014-10-28 Thread Emanuel Calvo
-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.ca...@2ndquadrant.com> wrote: > >> >> El 23/10/14 a las 17:40, Joe Van Dyk escibió: >>> Hi, >>> >>> I have a master and a slave database.

Re: [GENERAL] some queries on standby preventing replication updates

2014-10-28 Thread Joe Van Dyk
On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo < emanuel.ca...@2ndquadrant.com> 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 ma

Re: [GENERAL] some queries on standby preventing replication updates

2014-10-27 Thread Emanuel Calvo
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

[GENERAL] some queries on standby preventing replication updates

2014-10-23 Thread Joe Van Dyk
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 o