Hacker News new | ask | show | jobs
by justinclift 53 days ago
What's the underlying filesystem(s) you're using for the data storage?
1 comments
daneel_w 52 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.
link
justinclift 52 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 52 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