Re:Postgres Incremental Backup
by ddorian43 on Friday January 12, 2024 @02:26AM
(#38965104)
The egrees fees will be bigger than your db cost.
[ Parent
| on HN ]
Yes, maybe (some kind of diff/sync could maybe help), but this means using such a cloud is a bad IT practice.
Re:Postgres Incremental Backup
by theanirudh on Friday January 12, 2024 @06:48AM
(#38967004)
Yes, the egress fees on base backups alone were higher than the cost of the DB VMs. If we replicate the WAL also, it would be way higher. In the post, the example DB was 4.3 GB, but the WAL created was 77 GB.
The joys of WAL bloat [0]. UUIDv4s?
[0]: https://www.2ndquadrant.com/en/blog/on-the-impact-of-full-pa...