Re: [PERFORM] Replication Lag Causes

2014-11-02 Thread Mike Wilson
. Mike Wilson > On Nov 2, 2014, at 12:33 PM, Greg Spiegelberg wrote: > > Hi Mike, > > Sounds very familiar. Our master fans out to 16 slaves (cascading) and we > had great success with segregating database queries to different slaves and > some based on network late

Re: [PERFORM] Replication Lag Causes

2014-11-02 Thread Mike Wilson
AL can be replayed by only one process, so no need to increase the > max_wal_senders. > > Cheers, > > -- Valentine Gogichashvili > > On Sun, Nov 2, 2014 at 1:33 AM, Mike Wilson <mailto:mfwil...@gmail.com>> wrote: > I have two 9.3.4 PG instances that back a l

[PERFORM] Replication Lag Causes

2014-11-01 Thread Mike Wilson
heavily hit databases and maintain small lag times? I would like to believe that the fault is something we have done though and that there is some parameter we could tune to reduce this lag. Any recommendations would be very helpful. Mike Wilson Predicate Logic Consulting