PostgreSQL provides an elegant way to handle problems such as overlapping reservations, duplicate-event windows, or effective-date ranges. A typical design uses a […]
Read More
Use pg_trgm Instead of Reverse-Column Indexes for Suffix LIKE Searches
Searching for values that end with or contain a particular string can be tricky with a traditional index. A predicate such as: […]
Read MoreHow to Diagnose an Invalid YSQL Index in YugabyteDB
When an index appears as INVALID in YugabyteDB, the first question is usually: Why did the index become invalid? For example, d […]
Read MoreAdvanced YSQL Index Backfill Tuning for Low-Tablet-Count and Partitioned Tables
YugabyteDB’s distributed index backfill can take advantage of multiple tablets and YB-TServers to build an index in parallel. In most environments, the […]
Read More