On 2 November 2014 05:33, Mike Wilson <mfwilson@gmail.com> wrote:
> Any recommendations would be very helpful.
Try using ionice and renice to increase the priority of the WAL sender
process on the master. If it helps, you are lagging because not enough
resources are being used by the sender process (rather than the slave
having trouble, for example). Lowering the number of concurrent
connections in your pgbouncer connection pool could help here.
--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/