In a distributed SQL database like YugabyteDB, understanding where data actually lives is just as important as understanding the schema itself. Once […]
Read More
Understanding Smart-Driver Pooling with Multiple Connection Pools (and Important Known Issues)
In a [previous tip], we enforced a global max connection limit while load balancing Npgsql connections across a YugabyteDB cluster. That earlier […]
Read MoreDecode yb_local_tablets() Split Ranges into Human-Readable Bounds
When you manually pre-split a YugabyteDB table, using SPLIT AT VALUES, you’re telling the database exactly how to divide its key space […]
Read MoreHow to Enforce a Global Max Connection Limit When Load Balancing Npgsql Connections
When connecting to a distributed SQL cluster like YugabyteDB using Npgsql, it’s easy to assume that MaxPoolSize places a global limit on […]
Read MoreHow 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 More