I don't think you read the comment thoroughly. This is the point.

Also, the discussion is centered around ZFS, there's no reason to bring up LVM. Everyone knows there's many ways to skin this cat and it doesn't make anyone appear any smarter because they know of one way.

That's the point. If you mess up your db doing something you want to lose all the data since you created the snapshot.

>You've been able to do this for years on Linux with LVM anyway.

What's the point of saying this in that tone? I could achieve the same goal in a number of different ways - that doesn't make any of those methods invalid because another one exists.

> Except you'll lose all the data since you created the snapshot...

Yes, but that's the point

You're right about LVM though

The original poster should have advised people to clone the snapshot. Then you instantly have a copy elsewhere that you can use for experiments without disturbing the original.