TL;DR When a query plan changes in production, teams often try to copy production data into another environment to reproduce the issue. […]
Read More
Use VmHWM to Catch “Memory-Heavy” YSQL Backends (and Help Prevent OOMs)
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 More