Indexes Under The Hood
Many things can improve database performance. One of the most obvious solutions is to use indexes. This blog post will examine them in detail to understand how they work in PostgreSQL and what makes them useful.
Many things can improve database performance. One of the most obvious solutions is to use indexes. This blog post will examine them in detail to understand how they work in PostgreSQL and what makes them useful.

Understanding error budgets (like 1% for a 99% SLO) as a percentage rather than a static count is crucial, and burn rate—a preferable metric—directly compares your current error rate to this budget for intuitive, actionable insights, reducing alert noise when implemented over multiple windows as adv.. read more

Time series databases like VictoriaMetrics, Prometheus, and InfluxDB efficiently handle vast amounts of timestamped data and have become crucial for applications in infrastructure monitoring, finance, IoT, and manufacturing, with open source solutions providing superior performance and flexibility c.. read more

Pieter Levels advocates for simplicity in infrastructure by running micro-SaaS businesses on single servers, avoiding unnecessary complexity like Kubernetes from day one and instead focusing onproduct-market fit and effective use of powerful modern servers... read more

Multi-stage Docker builds dramatically optimize image sizes, improve security, and speed up builds by separating build dependencies from runtime, leveraging multiple stages within a single Dockerfile for more efficient caching and maintainable workflows—a game-changer for complex applications... read more
PromCon 2024 Day 1 showcased the beta release of Prometheus 3.0 with improved OpenTelemetry compatibility, cost optimizations, upgraded Remote Write 2.0, and the introduction of UTF-8 support for metrics and label names, while Shopify shared its journey to native histograms and Martin discussed scal.. read more

AWS outlines disaster recovery options, including warm standby (a scaled-down but functional secondary environment) and active/active (a full environment for zero downtime) where warm standby is "hotter" and faster to restore than pilot light, which requires additional action to handle traffic... read more

Materialized View Capital (MVC) officially launched to invest in early-stage infra startups, while the Prefect Summit 2024 keynote covers critical trends like primary persistence on object storage, composable databases, PostgreSQL's renaissance, and durable execution—reflecting shifts from monolithi.. read more

GitHub's dominance resulted from its perfect timing as distributed version control tools emerged and itsdeveloper-focused approachthat refocused code hosting around user-centric and permission-simplistic models, unlike ad-driven competitors... read more
