Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

What drives me mad is when people claim they choose PostgreSQL over MySQL because data integrity concerns, yet they run PostgreSQL on Linux as opposed to FreeBSD or Illumos using ZFS.


Postgres' MVCC is almost like copy-on-write by itself, so anything more than a journal is overkill in any realistic scenarios.

Personally we tried ZFS with PostgreSQL and we managed to fill the WAL drive before the vacuum could clear it out with our update rate.

So we went back to XFS on the more commonly adopted (in our company); CentOS




Consider applying for YC's Winter 2027 batch! Applications are open till November 2.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: