4 ms·
>Everyone speaks about InnoDB and how performant and reliable it is What? Everyone speaks about how unreliable it is and how many major data corruption proble
by MustardTiger 10y ago
>Everyone speaks about InnoDB and how performant and reliable it is
What? Everyone speaks about how unreliable it is and how many major data corruption problems it has.
>I have never heard much about storage engines in Postgres, why could this be so?
Because they didn't take the approach of having multiple storage engines, they just made one that works and is not easily removed from the database.
- evanelias 10y agoYou may be confusing InnoDB with MyISAM (which is prone to corruption, especially upon crashes) or with running MySQL without a strict SQL mode (which causes bad things like silent truncation of overflowing values). InnoDB is, and always has been, a very reliable and durable storage engine with solid performance characteristics.
- MustardTiger 10y agoNo, I am referring to innodb, which has a number of known reliability problems which are "wontfix".
- evanelias 10y agoCare to share examples?