Re: Replication Lag Causes - Mailing list pgsql-performance

From Stuart Bishop
Subject Re: Replication Lag Causes
Date
Msg-id CADmi=6N-eML3_XWBKKhBo7zhnjcmY3UT5ZBY6Za+b9UCGA3fcA@mail.gmail.com
Whole thread Raw
In response to Replication Lag Causes  (Mike Wilson <mfwilson@gmail.com>)
List pgsql-performance
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/


pgsql-performance by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: assignment vs SELECT INTO
Next
From: Simon Riggs
Date:
Subject: Re: unnecessary sort in the execution plan when doing group by