How Database Indexes Actually Work @AntonPutra
How Database Indexes Actually Work  @AntonPutra
Uploaded October 2026 | Updated November 2026, 3 hours ago
Learn how database indexes actually work, step by step on PostgreSQL with 10 million orders: why a full table scan freezes a page, how a sorted list and a B-tree find rows in a few reads, why the planner sometimes skips an index, and what each index costs on writes.

► Try it yourself: antonputra.com/exercises/database-indexes

▬▬▬▬▬▬▬ Timestamps ⏰ ▬▬▬▬▬▬▬
0:00 Intro: the page that freezes
0:54 Why it freezes: the full table scan
1:49 A sorted list: the index
2:45 The B-tree that keeps it fast
4:25 When the database skips the index
5:35 What indexes cost

▬▬▬▬▬▬ Connect with me 👋 ▬▬▬▬▬▬
► LinkedIn: linkedin.com/in/anton-putra
► Twitter/X: twitter.com/antonvputra
► GitHub: github.com/antonputra
► Email: me@antonputra.com

#database #devops
How Database Indexes Actually WorkArgoCD Notifications (Successful/Failed Deployments)Introduction to Kubernetes - Part 1Application Monitoring - 4 Golden SignalsQuarkus (Java) vs Fiber (Go): Performance Benchmark in Kubernetes #201Terraform Tutorial for Beginners (State, Import, Modules, Provisioners, Variables, Locals)Go vs. Rust: Performance BenchmarkTerraform Tutorial on AWS - Getting StartedgRPC vs. Kafka performance benchmarkRuby on Rails vs Node.js PerformanceMySQL vs PostgreSQL Performance Benchmark (Latency - Throughput - Saturation)Kubernetes NodePort vs LoadBalancer vs Ingress
Anton Putra |

How Database Indexes Actually Work

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER