When a YugabyteDB table is assigned to a custom tablespace, it is reasonable to assume that any secondary indexes created on that […]
Read More
Why Won’t pg_operator Cache in YugabyteDB?
YSQL catalog cache preloading can reduce the catalog reads performed when a new PostgreSQL backend processes its first queries. However, on older […]
Read MoreFind YugabyteDB Syscache IDs for yb_neg_catcache_ids
YSQL relies heavily on PostgreSQL’s system catalog cache, commonly called the catcache, to avoid repeatedly reading metadata from system catalog tables such […]
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