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 More
Preserve 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 MoreAutomating Local-Read Indexes When a New Region Is Added
In a previous YugabyteDB Tip, Replicating a Small Dimension Table for Local Reads in Every Region, we looked at how to use […]
Read MoreReplicating a Small Dimension Table for Local Reads in Every Region
Sometimes you have a small dimension table that is read constantly, joined frequently, and rarely updated. For example, maybe every application region […]
Read More