A routine ANALYZE flipped a Postgres query plan from an index scan to a sequential scan, and our API went from 12ms to 8 seconds. Here's what we learned about a failure mode most teams never think about.
- Published On
postgres
- A client moved their reads to database replicas for performance. The latency numbers looked great — until customers started getting charged twice and inventory counts drifted from reality.
- Published On
- A consulting war story about a PostgreSQL-to-MongoDB migration that went sideways, what we missed in planning, and the uncomfortable lessons about knowing when not to migrate.
- Published On
- A journey through implementing efficient sandbox environments using PostgreSQL schemas, exploring different approaches and their trade-offs.
- Published On
Tags
consulting (45)debugging (20)architecture (15)developer-experience (14)reliability (13)devops (7)observability (7)performance (7)code-quality (6)ai (6)kubernetes (4)postgres (4)database (4)technical-debt (3)microservices (3)testing (3)engineering-culture (3)databases (2)security (2)opentelemetry (2)monitoring (2)postgresql (2)productivity (2)ci-cd (2)tooling (2)javascript (2)goals (2)error-handling (1)secrets-management (1)webhooks (1)infrastructure (1)resilience (1)containers (1)environments (1)queues (1)cloud (1)cost-optimization (1)orm (1)refactoring (1)on-call (1)alerting (1)incident-management (1)typescript (1)distributed-systems (1)caching (1)platform-engineering (1)dependencies (1)deployment (1)code-review (1)feature-flags (1)api (1)contracts (1)logging (1)mongodb (1)migration (1)workflow (1)nestjs (1)angular (1)sandbox (1)sonarcube (1)learning (1)journey (1)mdx (1)