Long-Running API Requests Done Right: The 202 Accepted + Polling (or Callback) Pattern
Requests that take 30 seconds don’t belong on the request path. Convert a slow export endpoint into an async job: 202 Accepted, a status resource, polling, TTLs.
Pillar: Pillar 14 - Scalability & Performance Headroom
Pillar 14 · Evolve
This Fixes: Slow LIKE and ILIKE Queries With pg_trgm
A ‘%term%’ search sequential-scans a million rows because a B-tree cannot help a leading wildcard. A pg_trgm GIN trigram index makes ILIKE and fuzzy search fast.
UUIDv7 vs bigint Identity: Choosing a Primary Key Type
Random UUIDs scatter B-tree inserts and bloat indexes; sequential bigints leak counts. UUIDv7 gives you distributed generation with good index locality. How to choose.
Why Did My App Exhaust Postgres Connections Under Load?
Your service throws FATAL: sorry, too many clients already and stalls. Here is how to trace it to an unbounded app pool and fix it with bounded pools and PgBouncer.
Swap on a Modern Linux Server: zram, a Swapfile, and When to Use Which
Cloud images ship with no swap, so processes get OOM-killed under transient pressure. Here is a layered fix: compressed zram, a disk swapfile fallback, and server-appropriate swappiness.
This Fixes: 413 Payload Too Large and Silent Truncation on File-Upload Endpoints
A 413 on an upload endpoint is a limits problem spread across the stack. Align the nginx and FastAPI body caps and stream large files to disk instead of RAM.
Why Did My Postgres Query Suddenly Spill to Disk? (work_mem and Hash/Sort Spills)
A query that ran in memory now writes gigabytes of temp files. Read the EXPLAIN ANALYZE spill lines, correlate them with log_temp_files, and fix work_mem without OOM-ing the box.
Instant Payments Meet the Core: Re-Architecting a Bank Ledger for Real-Time, Irrevocable Postings
The Instant Payments Regulation forces batch-built cores to post irrevocable payments within seconds, 24/7. The fix touches the ledger, fraud and reconciliation, not just the gateway.
Why Isn’t Postgres Using My Index?
You built the index and the plan still shows a Seq Scan. Here are the six real reasons the Postgres planner ignores an index that matches — each with a reproduction and a fix.
B-tree, GIN, BRIN and Hash: A Postgres Index Type Cheat-Sheet
A decision reference for PostgreSQL 17 index types: which one to reach for given the column, the operator and the query shape, with CREATE INDEX syntax and trade-offs.