A multi-column IN predicate is a convenient way to perform a batch of point lookups: SELECT item_id, description, category_id, state_code, lookup_hash, version, […]
Read More
Reduce Master Reads During YSQL Connection Churn with Authentication Caching
Applications that frequently open and close YSQL connections can generate more database work than the SQL being executed might suggest. Every fresh […]
Read MoreDiagnosing YSQL Backend Memory Usage
When troubleshooting YSQL memory, there are really three different questions: 1. How much memory is being used?2. Which YSQL backend is consuming […]
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