Sometimes you need to force a specific query plan, even when the query includes an IN (…) list whose length changes at […]
Read More
Export Optimizer Statistics with SQL Only (No cbo_stat_dump Required)
In a previous YugabyteDB Tip, we explored how to use cbo_stat_dump to recreate production optimizer behavior in a clean environment: 👉 Recreating […]
Read MoreWrite Pipelining (Async Writes) – Faster Writes, Even Across Regions
⏳ 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 More