Point-in-Time Recovery (PITR) in YugabyteDB protects databases from accidental DDL and DML by allowing recovery to a previous point within a configurable […]
Read More
How to Diagnose and Fix Stalled Index Backfills in YugabyteDB
Index backfill in YugabyteDB allows you to create new indexes on large tables without blocking reads or writes. However, backfill can stall […]
Read MoreHow to Speed Up YSQL Index Backfill (Especially on Large Tables)
Online index creation in YugabyteDB is powerful… you can add columns, create indexes, and keep the application running without blocking reads or […]
Read MoreWhen the CBO Doesn’t Choose a Local Covering Index (And How to Work Around It)
📝 Introduction YugabyteDB’s cost-based optimizer (CBO) is designed to pick the lowest-cost execution plan. When using duplicate covering geo-localized indexes, this usually […]
Read More