Indexing in PostgreSQL vs MySQL
from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser
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
Embed this episode
No transcript yet.
Frequently asked questions
How long is this episode of The Backend Engineering Show with Hussein Nasser?
This episode is 13 minutes long.
When was this The Backend Engineering Show with Hussein Nasser episode published?
This episode was published on October 13, 2020.
Can I download this The Backend Engineering Show with Hussein Nasser episode?
Yes. Use the download control on the episode player to save the publisher-provided media file.