3 ms·
I find it hard to believe that many would use SW RAID with Postgres in production, especially under load conditions that were tested for here. I have seen littl
by rsa4096 9y ago
I find it hard to believe that many would use SW RAID with Postgres in production, especially under load conditions that were tested for here. I have seen little hope for performant SW RAID on Linux in the past twenty years. It would be interesting to see the same tests run using stable HW RAID of some sort (preferably, with SSDs)
- chasil 9y agoZFS raidz is software raid. If you want the ability to scrub (in such a way that detects errors over the whole storage stack), you must sacrifice hardware raid. You must also pay the fletcher/sha256 tax. ZFS enthusiasts advocate that critical data absolutely requires those sacrifices. I'm inclined to agree.
- X86BSD 9y agoYou don’t HAVE to checksum. You can set checksumming to off. It’s foolish and defeats the point of keeping your data safe but ZFS gives you the ability to commit suicide if you choose.
- rsa4096 9y agoI should have been more specific. I find it hard to believe many would use Linux software raid (i.e. md) for Postgres in production.