- Published on
How to compare SKIP LOCKED, plain FOR UPDATE, and advisory lock job claims in PostgreSQL with a runnable pgbench harness and a claim-strategy decision table.
Performance
All Posts
- software-engineering (26)
- backend (24)
- reliability (21)
- distributed-systems (15)
- databases (14)
- production-systems (9)
performance (8)
- architecture (7)
- api-design (6)
- testing (5)
- microservices (5)
- fundamentals (4)
- observability (4)
- debugging (4)
- sql (4)
- best-practices (3)
- cascading-failures (3)
- systems (3)
- code-review (2)
- engineering-process (2)
- ci (2)
- Published on
How database connection pool exhaustion happens under load, how to tell pool wait from slow SQL, and how to size pools across instances safely.- Published on
A production workflow for finding slow SQL queries, reading EXPLAIN plans, choosing fixes, and proving the endpoint improved.- Published on
How to detect and fix the N+1 query problem in ORMs with query counts, SQL traces, eager loading, batched IN queries, and request-scoped loaders.- Published on
Why adding more service instances can leave throughput flat when the bottleneck is a shared database, lock, connection pool, queue, or dependency.