
Backend Development43 min
Postgres Dead Tuples Not Being Removed: Fixes (2026)
Postgres dead tuples not being removed? VACUUM can only delete rows older than the xmin horizon. Here is how to find what holds it back, and how to fix it.
in this category
Server-side development, APIs, databases, Node.js, Python, microservices, and backend architecture
64 posts
Page 1 of 6

Backend Development43 min
Postgres dead tuples not being removed? VACUUM can only delete rows older than the xmin horizon. Here is how to find what holds it back, and how to fix it.

Backend Development21 min
BullMQ worker not processing jobs? Work through queue name and prefix, maxRetriesPerRequest, stalled-job locks, and the v6 ioredis peer dependency change.
Backend Development14 min
Postgres 18 lets MERGE RETURNING return old and new row values in one query. See merge_action(), the xmax alternative, and verified Node.js/TypeScript code.
Backend Development12 min
Add a correlation ID to every log line in Node.js with built-in AsyncLocalStorage and Express — typed, zero-dependency, plus pino and downstream propagation.
Backend Development17 min
Build a production Node.js circuit breaker in TypeScript with opossum: closed, open, half-open states, fallbacks, errorFilter, timeouts, and verified output.
Backend Development16 min
Implement Postgres row-level security for multi-tenant apps with node-postgres: enable RLS, write current_setting policies, and avoid the pool-leak footgun.
Backend Development11 min
Query nested relations in Drizzle ORM with db.query and the with operator: filter and limit child rows, run many-to-many joins, plus the v1 vs v2 changes.
Backend Development11 min
Build a fully type-safe tRPC v11 API in TypeScript: a standalone server, a vanilla client, Zod validation, and error handling. No framework, all runnable.
Backend Development10 min
Use Postgres 18's built-in uuidv7() for primary keys: default DDL, uuidv7 vs uuidv4 vs bigint, migrating off uuidv4, and the timestamp-leak caveat to know.
Backend Development14 min
Connect Valkey from Node.js and TypeScript with the iovalkey client: Docker setup, typed caching, pipelines, pub/sub, error handling, and graceful shutdown.
Backend Development18 min
Build a typed, production gRPC service in Node.js and TypeScript: server streaming, deadlines, the error model, and health checks. Runnable 2026 guide.
Backend Development9 min
Should you use Postgres LISTEN/NOTIFY for a job queue? The global commit lock, 8000-byte payload cap, PgBouncer limits, and safer SKIP LOCKED patterns.