Topic notes

PostgreSQL

Indexing, SKIP LOCKED queues, and UUID key design for PostgreSQL systems.

Start with the query and delivery contract, then choose indexes, locks, and identifiers that fit the operational trade-off.

Topic notes

A Database Is Not a JSON Blob: Let Constraints Protect Data

#PostgreSQL#database#SQL+2

2026-08-23

PostgreSQL 18 Skip Scan: The Leftmost Rule, Revisited

#PostgreSQL#database#B-tree+2

2026-08-11

PostgreSQL SKIP LOCKED: Job Queue, Not Magic Broker

#PostgreSQL#database#concurrency+1

2026-08-14

UUIDv7 for Primary Keys: Better, Not Universal

#PostgreSQL#database#UUIDv7+2

2026-08-05