Indexing in PostgreSQL vs MySQL - podcast episode cover

Indexing in PostgreSQL vs MySQL

Oct 13, 202014 min
--:--
--:--
Download Metacast podcast app
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

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

For the best experience, listen in Metacast app for iOS or Android