2 ms·
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 FreeBS
by infamouscow 10y ago
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.
- dijit 10y agoPostgres' 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