2 ms·
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 Pos
by dijit 10y ago
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