B-TREE versus Row Heap. Which database has the better engine?
Ben Dicken · 13:47 · Watch on YouTube
MySQL’s InnoDB stores each table as a clustered B+ tree whose leaf pages are the rows, while Postgres appends rows into an unordered heap and keeps a separate B-tree index that points at those heap tuples. The operati...