Suppose your YugabyteDB universe spans three regions. You’ve ranked one region as the first choice for tablet leaders and the others as […]
Read More
Declarative Partitioning in YugabyteDB: Great for Data Purging… But Know the Trade-Offs
YugabyteDB supports PostgreSQL-style declarative table partitioning, including RANGE, LIST, and HASH partitioning. That can be especially useful for large tables where data […]
Read MoreSafely Resolve an Inverted Index Dependency on a YugabyteDB Partition
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 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 More