Go Gin OpenTelemetry Trace Context Propagation
Distributed trace context links spans from separate services into one request path. Begin with an invariant that the service must preserve even when users...
Blog
All troubleshooting articles, newest first.
Go HTTP Server Timeouts for Slow Client Protection
Server read, header, write and idle timeouts bound different stages of an HTTP connection. Begin with an invariant that the service must preserve even when...
PostgreSQL Advisory Locks vs SELECT FOR UPDATE for Job Queues
For a job queue in PostgreSQL, SELECT FOR UPDATE SKIP LOCKED inside a transaction is usually the simplest and safest way to let many workers claim jobs without...
PostgreSQL Foreign Key Indexing Strategy for Join Heavy Queries
PostgreSQL creates an index on the referenced primary key but not on the foreign key column that points to it. Without an index on the referencing column,...
PostgreSQL Table Partitioning by Time for Large Event Tables
Partitioning a large PostgreSQL event table by time splits it into smaller child tables, usually one per day or month. The main benefits are fast data...
PostgreSQL Row Level Security for Multi Tenant SaaS
Row-level security adds database-enforced row visibility policies but does not remove the need for application authorization. Begin with an invariant that the...
PostgreSQL Concurrent Index Creation and Deployment Safety
CREATE INDEX CONCURRENTLY reduces blocking of ordinary writes, but has special transaction and cleanup constraints. Begin with an invariant that the service...
PostgreSQL Exclusion Constraints for Scheduling Conflicts
Exclusion constraints can prevent overlapping reservations across indexed ranges directly in the database. Begin with an invariant that the service must...
Docker Container Capabilities vs Privileged Mode in Production
Privileged containers receive broad host-facing permissions that are rarely justified by one application feature. Begin with an invariant that the service must...