InnoDB vs Postgres primary keys

A 3D stack of index layers that compares how MySQL InnoDB and PostgreSQL store a primary key, with queries that light up the pages each engine reads.

Drag the stack in any direction to turn it.

Run
    MySQL pages read
    –
    PostgreSQL pages read
    –

    The example table has 6 products, so each tree has one root node and two leaves. Real tables have more levels, and the pattern stays the same.

    Drag the stack in any direction to turn it.