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
Automatically keeping table statistics up to date for better query plans
🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
Read MoreAvoid Cache Invalidation When Analyzing Tables
YugabyteDB’s cost-based optimizer (CBO) is a big deal. Turn it on, keep stats fresh, and your plans get smarter, closer to PostgreSQL […]
Read MoreReset Table Statistics
When working with cost-based optimization (CBO) in a distributed SQL database like YugabyteDB, keeping your table statistics accurate is crucial for optimal […]
Read More