In this video, I explain how both Postgres and MySQL store their indexes and their effect on reads vs writes. Let us discuss
0:00 Intro
1:00 Tables
2:00 Indexes
3:20 Indexing in Postgres
5:00 Indexing in MySQL
6:35 What Happens on Update on Postgres
7:20 What Happens on Update on MySQL
9:00 Reads on Postgres
9:40 Reads on MySQL
--- Send in a voice message: https://anchor.fm/hnasr/message