YugabyteDB supports the PostgreSQL pgcrypto extension for column-level encryption. But encrypting a column raises an interesting sizing question: How much larger does […]
Read MoreSafely Use Dynamic Tenant GUCs with RLS and YSQL Connection Manager
A common multi-tenant design is to use a shared application database role and identify the active tenant with a custom YSQL configuration […]
Read MoreHow to Diagnose an Invalid YSQL Index in YugabyteDB
When an index appears as INVALID in YugabyteDB, the first question is usually: Why did the index become invalid? For example, d […]
Read MoreAdvanced 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 More