Hacker News new | ask | show | jobs
by daneel_w 48 days ago
Ext4 with journaling. I've played around with XFS as well just to see what would happen. No major difference. I'm certain it's caused by the way Postgres builds its indices.
1 comments
justinclift 48 days ago
No worries. Just checking if it was ZFS.

While I really like ZFS personally for 99% of things, for "need maximum performance with PostgreSQL and we're already pushing high end hardware to the maximum" ZFS is reportedly the wrong choice.

link
daneel_w 48 days ago
We've reached the same conclusion in other situations. Great for reliable and scalable storage, not so great for focused intense i/o.
link