logo
episode-header-image
Oct 2020
13m 50s

Indexing in PostgreSQL vs MySQL

Hussein Nasser
About this episode

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

Up next
Jul 10
How a query optimization gave birth to infinite scroll
The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ... Show More
21m 20s
Jun 17
Postgres is half as fast in Linux 7.0
An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was di ... Show More
34m 8s
Jun 8
Don't let AI rob you
A discussion about why many engineers still love the struggle, the mistakes, and the process of figuring things out themselves. This is how we grow and get better and stronger. Letting AI do everything (even though it can’t) robs us this feeling.. 
31m 53s
Recommended Episodes
Oct 2023
166: Speedy Database Queries with Lukas Fittl
pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn. 
1h 12m
Apr 2023
#1028: Databases
<p>In this podcast, I talk about one of the most important tools we use for Magic design—databases. I walk through the history of our databases and explain how we use them.</p> 
30m 52s
Sep 2025
940: Picking a Fullstack Stack, Is Next.js Too Complex? Services vs Self-Hosted + More
In this potluck episode, Wes and Scott answer your questions about modern full-stack stacks, Node.js backend options, managing database indexes, developer burnout, handling toxic bosses, and more! Show Notes 00:00 Welcome to Syntax! 02:36 What’s your go-to Node.js backend in 2025 ... Show More
1h 5m
Apr 2020
Episode 15 - Compilers, Linters, and Formatters
In this episode of the programming podcast, we'll discuss static analysis and code transformation. In particular, we'll look at the difference between compilers, linters, and formatters. By the end of the episode, you'll understand what tool you should use to improve your develop ... Show More
8m 39s
Dec 2024
#491: DuckDB and Python: Ducks and Snakes living together
See the full show notes for this episode on the website at <a href="https://talkpython.fm/491">talkpython.fm/491</a> 
1h 2m
May 2019
How to Write Ranking YouTube Descriptions
In this episode, I show you how to gain more YouTube views and YouTube subscribers, by writing ranking YouTube descriptions. I go over a free template you can use that will rank your videos higher in YouTube search with great YouTube SEO. Keywordtool.io https://keywordtool.io/ Mu ... Show More
6m 7s
Sep 2021
Hashing It Out - Pranav Maheshwari - TheGraph
Today Corey talks with Pranav Maheshwari from The Graph, an indexing protocol for querying networks like Ethereum and IPFS. We'll dive deep into how The Graph works, what it aims to solve, what complications it has faced as it has scaled out to its current state, and where it exp ... Show More
1h 5m
Oct 2025
Got Email? - Part 2
In this podcast we talk about how to make your technology work for you, and how you can spend less time on email while getting more done. 
26m 56s
Jul 2024
Interview: Alex Tran and Zack Pollard (Immich)
Join me as I sit down for a casual discussion about self-hosting, FUTO, development, licensing, and other topics with Alex and Zack from the Immich development team.Episode Guest: Alex Tran, Zack PollardLinks:ImmichContainerized hardware acceleration for Immich via Tailscale (You ... Show More
1 h