Inside PostgreSQL and MySQL: Pages, CTID, Clustered Indexes, and MVCC
Every database "saves your data." But where does a row actually sit on your disk, and how does the database find it again in a table of 10 million rows?
This article opens up the two most popular rela
noobdiaries.hashnode.dev15 min read