3 ms·
It's very click-baity, but to provide some anecdotal evidence I've never had corrupted data/tables in Postgres, but dealt with it very regularly in MySQL under
by feld 12y ago
It's very click-baity, but to provide some anecdotal evidence I've never had corrupted data/tables in Postgres, but dealt with it very regularly in MySQL under almost identical environments.
MySQL doesn't do a great job of protecting your data compared to Postgres, MSSQL, Oracle, etc.
- feld 12y agoGo ahead, kill -9 your production MySQL servers. I dare you. I can do that to Postgres all day and the on-disk data integrity is preserved.
- kbenson 12y agoIt makes little sense to put it like that, since for MySQL it greatly depends on the storage engine used. I've found InnoDB to be quite robust, but I'm not sure how it compares to what Postgres uses.