When dropping an index from a partitioned YSQL table, you might encounter an unexpected error like this: ERROR: cannot drop index app.event_history_search_idx […]
Read More
Automate 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 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 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