Re: [GENERAL] 9.2 streaming replication issue and solution strategy

2012-11-20 Thread Kevin Grittner
Adrian Klaver wrote: > I am hoping to hear more from people who have running 9.2 systems > w/ between 100m and 1b records, w/ streaming replication and heavy > data mining on the slaves (5-50m records read per hour by multiple > parallel processes), while from time to time (2-3 times/week) > betwe

Re: [GENERAL] 9.2 streaming replication issue and solution strategy

2012-11-17 Thread Adrian Klaver
On 11/17/2012 07:33 AM, T. E. Lawrence wrote: Have you looked at the below?: http://www.postgresql.org/docs/9.2/interactive/hot-standby.html#HOT-STANDBY-CONFLICT 25.5.2. Handling Query Conflicts Yes, thank you! I am hoping to hear more from people who have running 9.2 systems w/ between 100

Re: [GENERAL] 9.2 streaming replication issue and solution strategy

2012-11-17 Thread T. E. Lawrence
> Have you looked at the below?: > > http://www.postgresql.org/docs/9.2/interactive/hot-standby.html#HOT-STANDBY-CONFLICT > > 25.5.2. Handling Query Conflicts Yes, thank you! I am hoping to hear more from people who have running 9.2 systems w/ between 100m and 1b records, w/ streaming replicat

Re: [GENERAL] 9.2 streaming replication issue and solution strategy

2012-11-17 Thread Adrian Klaver
On 11/17/2012 06:08 AM, T. E. Lawrence wrote: > Hello, > > We are running 9.2 w/ streaming replication. > > The slave is used for heavy tsearch based data mining. > > Apparently depending on the business of the master the slave queries fail > with different frequency with the following message