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.
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 |