Re: Weird spikes in delay for async streaming replication on 9.1

On Thu, 26 Feb 2015 10:40:31 -0500
John Scalia <jayknowsunix@gmail.com> wrote:

> Apologies, David, but as I don't check this list very often, I
> thought you should have received an answer. Have you tried watching
> the transaction with tcpdump or wireshark?

Yes.  Haven't observed anything unusual.

> To me this sounds like either a network problem or like you're
> thinking a contention problem.

It is not a network problem; we monitor the link between sites.  And it
happens absolutely regularly, like clockwork, when we run our nightly
pg_dump on the master.

> Also, are you running streaming replication? If so, there
> shouldn't be ANY delay as the standby gets the commit before the
> primary. Otherwise, how are you replicating? -- Jay

We are running asynchronous streaming replication.

Regards,

David.