Re: Weird spikes in delay for async streaming replication on 9.1 - Mailing list pgsql-admin

From David F. Skoll
Subject Re: Weird spikes in delay for async streaming replication on 9.1
Date
Msg-id 20150226104433.1b0df1db@hydrogen.roaringpenguin.com
Whole thread Raw
In response to Re: Weird spikes in delay for async streaming replication on 9.1  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: Weird spikes in delay for async streaming replication on 9.1
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: Weird spikes in delay for async streaming replication on 9.1
Next
From: John Scalia
Date:
Subject: Re: Weird spikes in delay for async streaming replication on 9.1