3x vdev zfs mirror array for postges - thoughts on u2.nvme drives

Notice: Page may contain affiliate links for which we may earn a small commission through services like Amazon Affiliates or Skimlinks.

jehu85

New Member
Feb 22, 2019
3
2
3
I haven't used the Micron 9300Pro or Samsung PM1735 specifically, but I've heard good things about both for heavy read/write workloads. They should handle your Postgres database pretty well, especially if you're moving away from AWS.
 

iotapi322

Member
Sep 8, 2017
77
14
8
49
Would be 6TB all Optane Pmem in application mode an option with 512GB modules? You could even do DRBD cluster w/2nodes for redundancy on the modules as storage. No disks etc involved. You still go through kernel level but it's still superior to any NVMe storage solution mentioned here. No slow ZFS pool requirements. Just 2x X11DPU units with 12x 512GB modules each. Did you test postgresql on local Minio storage build from the modules? You can go with superior XFS performance as JBOD and Minio takes care of data integrity. Performance wise it's far superior to ZFS.

ADD: Or build distrubuted storage as read ops seem to dominate. Like MooseFS with XFS and atomic snapshots. You will feel like you are in a different film compared with ZFS performance.
I don't know if ihave to go that fast, and some of that worries me....
 

iotapi322

Member
Sep 8, 2017
77
14
8
49
I haven't used the Micron 9300Pro or Samsung PM1735 specifically, but I've heard good things about both for heavy read/write workloads. They should handle your Postgres database pretty well, especially if you're moving away from AWS.
Thanks, I'm thinking the dell R640's with the samsung PM1735... they are priced just right.