Index backfill in YugabyteDB allows you to create new indexes on large tables without blocking reads or writes. However, backfill can stall […]
Read More
How 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 MoreEfficient CIDR Range Lookups Using Expression Indexes
🚀 Introduction YugabyteDB fully supports PostgreSQL’s inet and cidr datatypes, allowing you to store and manipulate IPv4 and IPv6 network addresses. However, […]
Read MoreHow to Disable (and Re-enable) an Index in YugabyteDB
Sometimes you want to temporarily disable an index … for example, to test the optimizer’s behavior without it, benchmark a new candidate […]
Read More