On Mon, May 16, 2022 at 09:56:34AM +0200, Thorsten Schöning wrote: > Is that simply the way it is or are there some optimizations possible > when using pg_dump? Am using Postgres 11 and don't see anything which > seems to help in this use-case. What I'd suggest: 1. Use -Fd, to have each table separately 2. Use -Z0 to avoid normal compression 3. Use `gzip --rsyncable` on the data, to make the backup smaller for transmit (though you will need to unpack it to restore), or play with other compressors, like xz depesz
