7 min listen
Indexing in PostgreSQL vs MySQL
Indexing in PostgreSQL vs MySQL
ratings:
Length:
14 minutes
Released:
Oct 13, 2020
Format:
Podcast episode
Description
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
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
Released:
Oct 13, 2020
Format:
Podcast episode
Titles in the series (100)
Episode 15 - I Wrote Bad Front-End Code by The Backend Engineering Show with Hussein Nasser