When troubleshooting YSQL memory, there are really three different questions: 1. How much memory is being used?2. Which YSQL backend is consuming […]
Read More
Advanced YSQL Index Backfill Tuning for Low-Tablet-Count and Partitioned Tables
YugabyteDB’s distributed index backfill can take advantage of multiple tablets and YB-TServers to build an index in parallel. In most environments, the […]
Read Morepg_stats.correlation Is Not a Monotonic Index Detector
Some columns naturally move in one direction as new rows are inserted. Think timestamps, event times, sequence values, or identity columns. These […]
Read MoreUse pg_stats to Spot Low-Cardinality Index Hotspots Before They Spot You
When migrating from PostgreSQL to YugabyteDB, table load time is only part of the story. Secondary indexes can become the real bottleneck. […]
Read More