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
Faster 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 MoreSpeeding Up JDBC Bulk Inserts in YugabyteDB YSQL
High-volume inserts into YugabyteDB YSQL can be significantly faster when write batching and buffering are configured correctly. Many insert performance issues are […]
Read MoreOrdering and indexing by time with UUIDv7
In our previous tip, Generate UUIDv7 in YSQL, we showed how to generate UUIDv7 values directly in YugabyteDB YSQL and use them […]
Read More