News for hackers. Stuff that matters.

A comment on Introducing WAL-G: Faster Disaster Recovery for Postgres. Parent comment

Re:Introducing WAL-G: Faster Disaster Recovery for Postgres by andruby on Tuesday August 22, 2017 @06:11AM (#15070999)
Yes, the lzop compression helps a lot, and I imagine that mostly "empty files" will be more compressible.

On a staging server with little activity, the compressed WAL-E wal files go as low as 1.9MB per 10 minutes. (~2GB/week)

The production server has files between 4 and 12MB per 1 minute or less. (~220GB/week)

WAL-E has a good `wal-e delete retain` command that removes older base backups and wal files.

[ Parent | on HN ]
Re:Introducing WAL-G: Faster Disaster Recovery for Postgres by ngrilly on Tuesday August 22, 2017 @07:11AM (#15071280)
2 GB/week is so much better than 161 GB/week! It looks like compression helps a lot. Thanks for sharing these numbers.
[ Parent | on HN ]