How PostgreSQL Stores a Row
Every database gives you a row and every database lies a little about what that row is. MySQL gives you a record copied into a row buffer. SQLite gives you a record in a b-tree …
Postgres
How PostgreSQL Implements time and timetz in C
A PostgreSQL time is a 64-bit integer counting microseconds since midnight. A timetz is the same integer plus a 4-byte timezone offset. So far so simple. The interesting part is …
How PostgreSQL Speeds Up Hash Joins
A hash join is the simplest join algorithm in the database: build a hash table from the inner relation, then probe it once per outer row. There is no sort, no merge, no nested loop …
How PostgreSQL Implements numeric in C
numeric is PostgreSQL’s exact decimal type: arbitrary precision, no rounding surprises, no binary-vs-decimal conversion error. It is also the type where the storage format and the …
How PostgreSQL Waits for Locks
Every lock in PostgreSQL is a bet. When a backend wants a resource that somebody else has, it has to choose: burn CPU waiting, or go to sleep and let the kernel schedule somebody …