Filtering by date ranges looks simple… until it silently drops rows. If your column is a TIMESTAMP (not DATE), using <= ‘YYYY-MM-DD’ […]
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 MoreDemonstrating Hot Shard Detection (and Why a Tablet Can Refuse to Split)
You may see a tablet growing large and repeatedly attempting to split… only to fail with errors like: TABLET_SPLIT_KEY_RANGE_TOO_SMALL Failed to detect […]
Read MoreExploring Range Tablet Placement (and Which Split Point Created Each Tablet)
In a previous tip, we explored how yb_tablet_metadata makes it easy to see tablet leadership and replica placement across a YugabyteDB cluster. […]
Read More