3 ms·
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
by daneel_w 5mo 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.
- justinclift 5mo agoNo 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.
- daneel_w 5mo agoWe've reached the same conclusion in other situations. Great for reliable and scalable storage, not so great for focused intense i/o.