Re: design for parallel backup

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.

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