Search Results: Postgres

Engineers often feel deep ownership over the codebases they build, but this emotional attachment can clash with business realities. This article explores the delicate balance between caring for your work and recognizing that ultimately, the code belongs to the company—and why that's not a bad thing.

CloudNativePG introduces a groundbreaking approach to managing PostgreSQL extensions, decoupling them from core binaries using Kubernetes ImageVolume. This new method enables dynamic addition, easier evaluation, and simplified updates without building custom container images.

A developer shares the harrowing story of how 89 missing indexes on foreign keys caused catastrophic performance issues in their multi-tenant SaaS application, and the 4-minute fix that saved their launch.

Postgres.app bundles a curated set of PostgreSQL extensions and offers a streamlined path for adding more, all without the usual macOS build headaches. Developers can enable built‑in extensions with a single SQL command, or download and compile custom ones into a dedicated Application Support directory that survives updates. The result is a developer‑friendly workflow that keeps extensions up‑to‑date and secure.

Reddit has re‑engineered its comment service, moving from a monolithic Python stack to a domain‑specific Go microservice. The migration halved p99 latency for critical write operations, reduced downtime during peak traffic, and laid the groundwork for modernizing all four core models. The story illustrates how careful staged rollout, tap‑compare testing, and data‑store isolation can unlock performance gains in a high‑write, highly‑available system.

Cloudflare's recent global outage wasn't just a physical failure—it was a logical design flaw. The company's proposed solutions miss the critical point that preventing such failures requires rigorous database design and formal verification, not just more robust infrastructure.