A common multi-tenant design is to use a shared application database role and identify the active tenant with a custom YSQL configuration […]
Read More
Why a Partial Index Disappears Under a Generic Prepared Plan in YSQL
A partial index can work perfectly when you test a query with literal values, yet disappear when the same query is executed […]
Read MoreCreate Multiple Colocation Groups in One YugabyteDB Database with Tablespaces
YugabyteDB colocation is a great fit for applications that contain many small tables and indexes. Instead of creating a separate tablet for […]
Read MoreDo YugabyteDB Indexes Inherit Their Table’s Tablespace?
When a YugabyteDB table is assigned to a custom tablespace, it is reasonable to assume that any secondary indexes created on that […]
Read More