kta,
@kta@hostux.social avatar

In database land today. Thinking through striping and mirroring on . Klara Systems has unpacked a lot of this:

... This means two things: solid state and mirrors. SSD drives provide far lower latency than conventional drives possibly can. And mirrors provide far better random access performance than RAIDz can—particularly when we’re talking about small random access ops, which can’t be effectively spread across tons of disks in a wide striped vdev...

[1] https://klarasystems.com/articles/openzfs-storage-best-practices-and-use-cases-part-3-databases-and-vms/

kta,
@kta@hostux.social avatar

🤔 thinking of getting a 4 port HBA (sits on an 8x PCIe lane). Sticking an array of 4TB NVME drives on it. A pool with a 2-way mirror and a LOG vdev and backups on the 4th drive.

kta,
@kta@hostux.social avatar

Any pointers on ZFS for #postgresql databases out in the wild? A favorite configuration to consider?

ferki,
@ferki@fosstodon.org avatar

@kta I've found the following an interesting read a while back on the performance and robustness considerations of running on :

https://vadosware.io/post/everything-ive-seen-on-optimizing-postgres-on-zfs-on-linux/

Happy hacking!

  • All
  • Subscribed
  • Moderated
  • Favorites
  • PostgreSQL
  • ethstaker
  • DreamBathrooms
  • cubers
  • mdbf
  • everett
  • magazineikmin
  • Durango
  • Youngstown
  • rosin
  • slotface
  • modclub
  • kavyap
  • GTA5RPClips
  • ngwrru68w68
  • JUstTest
  • thenastyranch
  • cisconetworking
  • khanakhh
  • osvaldo12
  • InstantRegret
  • Leos
  • tester
  • tacticalgear
  • normalnudes
  • provamag3
  • anitta
  • megavids
  • lostlight
  • All magazines