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
Sep 18
SQL was a mistake
I like SQL but the standard should have included ways to hint instead of the abstraction of "let me do it for you" 
12m 27s
Sep 11
Caching is a cop-out
In this episode I explore why you should take some time to examine the operation you are caching before doing so. And why caching is a cop-out 
15m 41s
Aug 23
How open ai agents "hacked" hugging face
How open ai agents "hacked" hugging face 
17m 57s
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