Re: pg_dump performance issues

On Thu, Feb 22, 2024 at 11:41 AM Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:

> Dominique:
> > .... in the 10-12MB/s throughput range.....
>
> This has the faint smell of a saturated 100Mbps link in the middle
> (12*8=96Mbps)
>

Very good call Francisco! Thanks a lot.

Below is connecting to the v14 PostgreSQL host, from my Windows desktop.
So indeed, I'm not on 1Gb/s as I expected... I'll report back when this is
fixed.

Thanks again, --DD

C:\Apps\iperf3>.\iperf3.exe -c XX.YY.ZZ.13
Connecting to host XX.YY.ZZ.13, port 5201
[ 4] local XX.YY.ZZ.49 port 62617 connected to XX.YY.ZZ.13 port 5201
[ ID] Interval Transfer Bandwidth
[ 4] 0.00-1.01 sec 11.5 MBytes 95.9 Mbits/sec
[ 4] 1.01-2.00 sec 11.4 MBytes 95.7 Mbits/sec
[ 4] 2.00-3.01 sec 11.4 MBytes 94.9 Mbits/sec
[ 4] 3.01-4.00 sec 11.2 MBytes 94.9 Mbits/sec
[ 4] 4.00-5.01 sec 11.4 MBytes 94.9 Mbits/sec
[ 4] 5.01-6.00 sec 11.2 MBytes 94.9 Mbits/sec
[ 4] 6.00-7.01 sec 11.2 MBytes 94.0 Mbits/sec
[ 4] 7.01-8.00 sec 11.4 MBytes 95.8 Mbits/sec
[ 4] 8.00-9.00 sec 11.2 MBytes 94.7 Mbits/sec
[ 4] 9.00-10.01 sec 11.4 MBytes 94.9 Mbits/sec
- - - - - - - - - - - - - - - - - - - - - - - - -
[ ID] Interval Transfer Bandwidth
[ 4] 0.00-10.01 sec 113 MBytes 95.0 Mbits/sec sender
[ 4] 0.00-10.01 sec 113 MBytes 94.8 Mbits/sec
receiver

iperf Done.