Re: design for parallel backup

On Wed, Apr 22, 2020 at 12:20 PM Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> On 2020-04-20 22:36, Robert Haas wrote:
> > My suspicion is that it has mostly to do with adequately utilizing the
> > hardware resources on the server side. If you are network-constrained,
> > adding more connections won't help, unless there's something shaping
> > the traffic which can be gamed by having multiple connections.
>
> This is a thing. See "long fat network" and "bandwidth-delay product"
> (https://en.wikipedia.org/wiki/Bandwidth-delay_product). The proper way
> to address this is presumably with TCP parameter tuning, but in practice
> it's often easier to just start multiple connections, for example, when
> doing a backup via rsync.

Very interesting -- thanks!

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company