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