PostgreSQL Blocking Queries: Find the Root Blocker with pg_locks
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read
Archive
295 published
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read
Learn how Nx builds task graphs, when to use build vs ^build, how to centralize pipeline rules in targetDefaults, and how to debug wrong build order.
16 min read
Profile a slow monolith test suite, fix shared state so parallel tests are safe, then split by module and timing data without making flaky tests faster.
16 min read
Learn how trunk based development, fast pipelines, safe migrations and release safety let you deploy a monolith frequently, even daily, before splitting it.
13 min read
Learn how Nx build configurations, project.json targets and fileReplacements work, and when backend services should use runtime config instead.
13 min read
Learn how to classify dependencies, choose fallback responses, signal degraded results, and wire timeouts, retries and circuit breakers in microservices.
13 min read
Compare Redis Pub/Sub and Streams: delivery semantics, consumer groups, durability limits, crash recovery, and when each fits service-to-service messaging.
14 min read
Build a Spring Boot GraalVM native image, measure startup and memory fairly against the JVM, and fix reflection and closed-world failures before production.
13 min read
How token bucket, leaky bucket and sliding window rate limiting algorithms work, what traffic shapes they permit, and how to implement them safely at scale.
17 min read
Learn how B-Tree, GIN, BRIN and partial indexes work in PostgreSQL, when each fits your data and operators, and how to verify the choice with EXPLAIN.
14 min read
Learn when a shared script is enough and when an nx local plugin pays off for caching, project graph awareness, generators and inferred tasks.
12 min read
Learn when and how to declare Nx implicit dependencies for contracts, codegen and runtime links, how they drive affected detection, and when inputs fit better.
13 min read