Re: pg_dump performance issues

On 2/22/24 06:40, Dominique Devienne wrote: On Thu, Feb 22, 2024 at 12:20 PM Dominique Devienne > wrote: On Thu, Feb 22, 2024 at 11:41 AM Francisco Olarte mailto:fola...@peoplecall.com>> wrote: Dominique: > in the 10-12MB/s throughput ra

Re: pg_dump performance issues

On Thu, Feb 22, 2024 at 12:20 PM Dominique Devienne wrote: > On Thu, Feb 22, 2024 at 11:41 AM Francisco Olarte > 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) >> > > So indeed, I'm

Re: pg_dump performance issues

On Thu, Feb 22, 2024 at 11:41 AM Francisco Olarte 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,

Re: pg_dump performance issues

Dominique: On Thu, 22 Feb 2024 at 10:50, Dominique Devienne wrote: > In the past, I've read [this post][1] from Marc Millas that reports `pg_dump > ... | psql` at throughput around 500MB/s (5Gb/s) on a 10Gb/s network. That is half the theoretical bandwidth,more or less. > I tried against a v12

pg_dump performance issues

In the past, I've read [this post][1] from Marc Millas that reports `pg_dump ... | psql` at throughput around 500MB/s (5Gb/s) on a 10Gb/s network. Today, I've tried pg_dump on a single schema of 25 tables, 88K rows, 70MB total (as reported by pg total relation sizes). 1 table of 225 rows contains