Re: pg_dump performance issues

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: pg_dump performance issues
Дата
Msg-id CAFCRh-8T-d5HNro_g5UpLFGK3BgQOwzrgZe-W0Cv7ZU1WH65Tw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump performance issues  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: pg_dump performance issues
Список pgsql-general
On Thu, Feb 22, 2024 at 11:41 AM Francisco Olarte <folarte@peoplecall.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. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: How do you optimize the disk IO when you cannot assume a file will start at a boundary then?
Следующее
От: Sasmit Utkarsh
Дата:
Сообщение: Re: Postgresql assistance needed