HN user
Personal experience: We moved multiple PostgreSQL servers including a large one using 32 vCPUs to the equivalent ARM based instances, and the performance was about the same, but of course ARM instances are less expensive.
Bill Williams [1], perhaps best known for his 1983 game Alley Cat had CF, and suffered greatly because of the disease. He was 37 when he died. His book "Naked Before God: The Return of a Broken Disciple" is about his experience with CF and his faith.
The Digital Antiquarian has a well written article about Bill Williams' life [2].
1- https://en.wikipedia.org/wiki/Bill_Williams_(game_designer)
2- https://www.filfre.net/2016/01/bill-williams-the-story-of-a-...
Thanks, glad you liked it.
We have been running a large multi-TB PostgreSQL database on ZFS for years now. ZFS makes it super easy to do backups, create test environments from past snapshots, and saves a lot of disk space thanks to built-in compression. In case anyone is interested, you can read our experience at https://lackofimagination.org/2022/04/our-experience-with-po...
You can actually extract individual files from a snapshot by using the hidden .zfs directory like: /mnt-point/.zfs/snapshot/snapshot-name
Another alternative is to create a clone from a snapshot, which also makes the data writable.
Yes, the first snapshot is the big one, the rest are incremental. Restoring a snapshot is just one line really. Something like ;)
sudo zfs send -cRi db/data@2022-12-08T00-00 db/data@2022-12-09T00-00 | ssh me@backup-server "sudo zfs receive -vF db/data"
ZFS is a game changer for quickly and reliably backing up large multi-terabyte PostgreSQL databases as well. In case anyone is interested, here is our experience with PostgreSQL on ZFS, complete with a short backup script: https://lackofimagination.org/2022/04/our-experience-with-po...