I have two 9.3.4 PG instances that back a large internet website that has very
seasonal traffic and can generate large query loads. My instances are in a
master-slave streaming replication setup and are stable and in general perform
very well. The only issues we have with the boxes is that
Hello Mike,
what kind of load does the slave get?
what does the recovery process do on the slave during the times when lag is
being observed? Does it use 100% of the CPU?
WAL can be replayed by only one process, so no need to increase the
max_wal_senders.
Cheers,
-- Valentine Gogichashvili