YugabyteDB colocation is a great fit for applications that contain many small tables and indexes. Instead of creating a separate tablet for […]
Read More
Do 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 MoreAutomate Duplicate Regional Indexes on pg_partman Partitions in YugabyteDB
Follow-up tip: This tip builds on Preserve Regional Index Tablespaces with pg_partman Templates, which demonstrates how a custom pg_partman template can preserve […]
Read MorePreserve Regional Index Tablespaces with pg_partman Templates
Version scope: This tip applies specifically to YugabyteDB v2024.2 and earlier. The YSQL API in these releases is based on PostgreSQL 11, […]
Read More