166: Speedy Database Queries with Lukas Fittl

In this episode, Patrick and Jason cover Agentic Coding! 

Free Strategy Call: https://www.lewishuckstep.com/book-in-a-strategy-call

Join the community group: <a href="https://www.facebook.com ...

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 Hap ...

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) https://database.husseinnasser.com Why create Index blocks writes In this video I explore how create index, why does it block writes and how create index concurrently work and allow wri ...

Free Strategy Call: https://www.lewishuckstep.com/book-in-a-strategy-call

Join the community group: <a href="https://www.facebook.com ...