Re: Streaming Replication Networking Best Practices?

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: Streaming Replication Networking Best Practices?
Дата
Msg-id 9DF82A39-C753-486C-B896-C5346D19BE58@icloud.com
обсуждение исходный текст
Ответ на Re: Streaming Replication Networking Best Practices?  (Don Seiler <don@seiler.us>)
Список pgsql-admin

> On May 14, 2018, at 4:22 PM, Don Seiler <don@seiler.us> wrote:
>
> Ping shows a pretty solid latency of 49-50 ms.
>

Depending on your window size; that will determine the throughput (not to exceed the link speed).

TCP Window / latency = throughput; i.e. if the windows is 16kb with 50 ms latency the max throughput is 640kb/s or
5.12Mbps

16/.05 = 640kb/s

The window size will vary during the connection; it will start off small and then progress to your max setting.  Now
youneed to determine how large you window can get and what is it actually doing; that will require observing the
connectionvia tcpdump or similar tools.  Dropped packets will prevent the window size from increasing and also cause
retransmits.



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

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