Re: Log shipping in v8.4.7

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Log shipping in v8.4.7
Date: 2017-08-27 20:22:25
Message-ID: 20170827202217.n7tn6yiz3lampt26@squirrel.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Ron Johnson (ron(dot)l(dot)johnson(at)cox(dot)net):

> > On today's LANs, total archiving time is dominated by connection
> > startup time (how long does it take to transfer 16MB on a 10GbE link?
> > See...).
>
> And if we've only got a WAN link from one DC to another 360 miles away?

Well... TCP handshake will take much longer (>~ 10ms, if I got the 0s
right at the top of my head), and you can't cut anything off that time
(1.8e12 furlongs per fortnight, or 3e8 m/s, etc).
And then it's between TCP slow start and your link's bandwith (they
come in all kinds of speeds these days). Calculate and test...

Regards,
Christoph

--
Spare Space.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Koukoulis 2017-08-27 20:23:14 hrs, mins and seconds do not appear with to_char
Previous Message Ron Johnson 2017-08-27 19:32:48 Re: Log shipping in v8.4.7