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-...

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...

Nice - thanks for the info! I had no idea about the Toy Story 2 fiasco as well so this was a great read :)

Thanks, glad you liked it.

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.

A snapshot yes but not a zfs send stream which is a single file.

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...