A partial index can work perfectly when you test a query with literal values, yet disappear when the same query is executed […]
Read More
Create 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 MoreInherit Regional Tablespaces with pg_partman in YugabyteDB v2025.1 and Later
Version scope: This tip applies to YugabyteDB v2025.1 and later, where the YSQL API is based on PostgreSQL 15. For YugabyteDB v2024.2 […]
Read More