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

Поиск
Список
Период
Сортировка
От David F. Skoll
Тема Re: Weird spikes in delay for async streaming replication on 9.1
Дата
Msg-id 20150226104433.1b0df1db@hydrogen.roaringpenguin.com
обсуждение исходный текст
Ответ на Re: Weird spikes in delay for async streaming replication on 9.1  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: Weird spikes in delay for async streaming replication on 9.1  (John Scalia <jayknowsunix@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Weird spikes in delay for async streaming replication on 9.1
Следующее
От: John Scalia
Дата:
Сообщение: Re: Weird spikes in delay for async streaming replication on 9.1