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