Postgres JSONB vs JSON: When to Use Which
JSON keeps the original text. JSONB parses to a binary format. That difference governs every other trade-off.
JSONB, partial indexes, EXPLAIN, MVCC — the 80/20 of high-performance Postgres.
JSON keeps the original text. JSONB parses to a binary format. That difference governs every other trade-off.
Bottom up. Inside out. The numbers that matter, the numbers that lie, the patterns that scream 'add an index'.
B-tree, multi-column, partial, covering. Four index types fix nearly every slow query you'll ever write.
RLS pushes authorization into the database. Done right, it's the safest way to multi-tenant. Done wrong, it's a 10x slowdown.
MVCC creates dead tuples. Autovacuum cleans them. When it falls behind, your database silently dies.