TL;DR A previous YugabyteDB tip, Measure Total Postgres Backend Usage, showed how to measure total current backend memory usage using PSS (Proportional […]
Read MoreAvoid the Midnight Timestamp Trap (Use Half-Open Ranges)
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 More