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...

Read the full summary on retube