166: Speedy Database Queries with Lukas Fittl

186: Becoming a ManagerIntro topic: plastic welding kitsNews/Links:Parse.bot, turn any website into an API https://www.parse.bot/Gemini 3 https://blog.google/products/gemini/gemini-3/Depth Anything 3 https://github.com/ByteDance-Seed/Depth-Anything-3Wan 2.2 (run on runpod) https://ww ...  Show more

Intro topic: Asymmetric ReturnsNews/Links:NanoChat by Andrej Karpathy https://github.com/karpathy/nanochatPydantic AI https://www.marktechpost.com/2025/03/25/pydanticai-advancing-generative-ai-agent-development-through-intelligent-framework-design/1000th Starlink this year https://s ...  Show more

Postgresql database implements MVCC by creating a new row version for any update/delete/or insert. While this is a sound implementation to support concurrent transactions reading old version of the rows, it does have some side effects and this is what I want to discuss in this ...

Join Scott Hanselman as he sits down with Sai Srirampur, as they explore the intricacies of Postgres Replication and how it can be turbocharged using PeerDB. In the realm of databases, Postgres Replication is like a well-choreographed dance between servers. Sai takes us behind ...

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

Fantastic gains in Postgres 15! improved sorting by 371%. Normally you can avoid sorting by using an index access path. However, you can’t always have an index on every group by, order by, join or distinct predict. This will come handy. Let us discuss

Resources

< ...