On Oct 18, 2010, at 12:48 PM, Aleksey Tsalolikhin wrote:

> Hi.  Replication lags over 5 minutes behind (sometimes over 10 minutes
> behind) while pg_dump is running on the slave.
> 
> We monitor our replication lag using Bucardo's check_postgres.pl and
> it keeps showing up on the monitoring/alerting radar 4 times a day,
> when we do the pg_dump.
> 
> I've increased the alert threshold to 30 minutes as an immediate
> measure, but is there any way to reduce pg_dump's impact on
> replication?  or will we pretty much have to live with it?

Are you out of i/o bandwidth on the slave?