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

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: John Scalia <jayknowsunix(at)gmail(dot)com>
Subject: Re: Weird spikes in delay for async streaming replication on 9.1
Date: 2015-02-26 15:44:33
Message-ID: 20150226104433.1b0df1db@hydrogen.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 26 Feb 2015 10:40:31 -0500
John Scalia <jayknowsunix(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2015-02-26 15:51:55 Re: Weird spikes in delay for async streaming replication on 9.1
Previous Message John Scalia 2015-02-26 15:40:31 Re: Weird spikes in delay for async streaming replication on 9.1