Some columns naturally move in one direction as new rows are inserted. Think timestamps, event times, sequence values, or identity columns. These […]
Read More
Export Optimizer Statistics with SQL Only (No cbo_stat_dump Required)
In a previous YugabyteDB Tip, we explored how to use cbo_stat_dump to recreate production optimizer behavior in a clean environment: 👉 Recreating […]
Read MoreRecreating 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 More