When we write:
SELECT *
FROM users
WHERE id = 100;
Enter fullscreen mode
# 🔍 What Actually Happens When PostgreSQL Executes a SELECT Query?
When we write: SELECT * FROM users WHERE id = 100; Enter fullscreen mode Exit...
1,292 words~6 min read
Related reading
Postgresql Simplified
PostgreSQL Backend Developer Essentials: The Concepts I Learned Beyond CRUD When working...
How to Correctly Read a PostgreSQL EXPLAIN ANALYZE Output
A slow query lands in your lap. You run EXPLAIN ANALYZE and get back a wall of indented text that...
Closing Chapter 1: From Query to Data
We opened Chapter 1 with a single line, SELECT * FROM users WHERE id = 1. For that line to leave the...
How Postgres Writes Data: WAL, Shared Buffers, and the Illusion of Speed
As developers, we interact with databases every single day. We write a line of code like UPDATE users...
Debugging PostgreSQL Performance
Let's chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN...
Turning PostgreSQL Into an Integration Engine
I wanted to see how far PostgreSQL extensibility could go. Most People Think PostgreSQL Is Just a...