Indexing in PostgreSQL vs MySQL

Published: Oct. 13, 2020, 2:36 a.m.

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