⏳ Quick note on timing This tip took a little longer than usual to publish because I wanted to wait until Write […]
Read MoreRecreating Production Optimizer Behavior in YugabyteDB with cbo_stat_dump
TL;DR When a query plan changes in production, teams often try to copy production data into another environment to reproduce the issue. […]
Read MoreUse 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 More