Re: Streaming Replication Networking Best Practices?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Streaming Replication Networking Best Practices?
Дата
Msg-id 9882daba-b884-a17f-0437-d2041961d025@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Streaming Replication Networking Best Practices?  (Don Seiler <don@seiler.us>)
Ответы Re: Streaming Replication Networking Best Practices?
Список pgsql-admin
On 5/14/18 16:22, Don Seiler wrote:
> On Mon, May 14, 2018 at 2:53 PM, Rui DeSousa <rui.desousa@icloud.com
> <mailto:rui.desousa@icloud.com>> wrote:
> 
>     What is the latency between the two sites?  That is going to dictate
>     how much potential throughput a given TCP/IP stream could use.  You
>     may need tune your TCP/IP window to increase the throughput.
> 
> 
> Ping shows a pretty solid latency of 49-50 ms.

You might find that increasing the TCP receive buffer on the receiving
side will help.

Here is a bit of an explanation:

https://stackoverflow.com/questions/259553/tcp-is-it-possible-to-achieve-higher-transfer-rate-with-multiple-connections

I believe this mechanism is the reason (or at least one of them) why
using parallel rsync (for base backup) or parallel copying of archive
segments is sometime faster than straight streaming.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-admin по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: Streaming Replication Networking Best Practices?
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: Streaming Replication Networking Best Practices?