You created a tablespace, assigned its replica placement, and picked the preferred locations for tablet leaders. Then the application’s needs changed. Can […]
Read More
Are Your YSQL Sessions Connecting to the Preferred Region?
Suppose your YugabyteDB universe spans three regions. You’ve ranked one region as the first choice for tablet leaders and the others as […]
Read MoreDeclarative 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 More