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