search

prodrigestivill / docker-postgres-backup-local

Backup PostgresSQL to local filesystem with periodic backups and rotate backups.
https://hub.docker.com/r/prodrigestivill/postgres-backup-local
MIT License
760 stars 133 forks source link

Default compression level ? #147

Closed rkolka closed 7 months ago

rkolka commented 7 months ago

-Z6 can make compression a bottleneck. my results: -Z0 4min10sec 49.1GB file -Z6 21min33sec 15.0GB file -Z1 7min45sec 16.3GB file

-Z1 seems better compromise.

rkolka commented 7 months ago

With -Z0 postgres process is the bottleneck. Otherwise pg_dump %CPU is near 100%. image

prodrigestivill commented 7 months ago

Hello @rkolka,

Thanks for the analysis.

We lowered the compression level when not specified from 9 to 6 (default) in #43. We now lowered to 1 in 45f624e6e8415dcd110e4dfeec5b91860d8d6e69.

Thanks for your contribution.