⏳ Quick note on timing This tip took a little longer than usual to publish because I wanted to wait until Write […]
Read More
Recreating Production Optimizer Behavior in YugabyteDB with cbo_stat_dump
TL;DR When a query plan changes in production, teams often try to copy production data into another environment to reproduce the issue. […]
Read MoreNo More ANALYZE After CREATE INDEX in YugabyteDB 2025.2
TL;DR Starting in 2025.2.0.0 (and backported to 2025.1.3.0), YugabyteDB automatically updates pg_class.reltuples for both the base table and newly created index after […]
Read MoreFaster exact row counts in YugabyteDB using range sharding and tablet-level parallelism
Exact row counts are common in migrations, validation, and operational checks. In YugabyteDB, SELECT COUNT(*) is correct and already distributed, but it […]
Read More