On 2 November 2014 05:33, Mike Wilson <mfwilson@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> http://www.stuartbishop.net/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
