News for hackers. Stuff that matters.
Re:ZFS Is the Best Filesystem For Now by floatboth on Wednesday July 12, 2017 @05:08PM (#14756701)
Atomic snapshots like ZFS's are always consistent for Postgres. I guess other databases with a similar write-ahead log can be snapshotted as well?
Re:ZFS Is the Best Filesystem For Now by anarazel on Wednesday July 12, 2017 @05:27PM (#14756842)
> Atomic snapshots like ZFS's are always consistent for Postgres.

As long as you make sure to only use one filesystem, i.e. you don't place pg_xlog or some tablespaces on a different filesystem. You can get very weird corruption in such cases :)

Re:ZFS Is the Best Filesystem For Now by olavgg on Thursday July 13, 2017 @04:56AM (#14759778)
With ZFS you can also do atomic snapshots of multiple filesystems. https://serverfault.com/questions/608223/is-zfs-snapshot-r-o...
Re:ZFS Is the Best Filesystem For Now by jerry40 on Wednesday July 12, 2017 @06:09PM (#14757105)
Interesting. I played with ZFS years ago on opensolaris, I don't remember there were atomic snapshots. I definitely need to dive into ZFS again.