Better dual WAL shipping/streaming integration?

From: Stuart Bishop <stuart(at)stuartbishop(dot)net>
To: "List, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Better dual WAL shipping/streaming integration?
Date: 2013-06-17 11:25:59
Message-ID: CADmi=6OoU-43Tz80swPxc_YO_6fdjFqtDRbzGt2Q_wRWOPBY-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I currently have a number of servers using both streaming replication
and WAL shipping in the standard setup.

Occasionally, the primaries get large load spikes. Load climbs up,
things slow down. So much so that streaming replication starts lagging
because the WAL sender is being starved for resources. Eventually, the
slave disconnects. At which point it happily starts consuming the
shipped files and catches up again.

All this is working just fine and as designed (apart from the load
spikes, but that is my problem). However, I was thinking that it would
be better streaming replication did not attempt to pull down WAL files
that had already been shipped and were available locally. This would
save resources when you need them most - the hot standbys have fallen
behind.

--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2013-06-17 11:45:41 UTC houroffset -> days_start AT TIME ZONE x
Previous Message Petko Godev 2013-06-17 11:04:52 Re: WIN1251 localization