A YSQL major-version upgrade is different from a normal YugabyteDB software upgrade. Moving from a PostgreSQL 11-based YugabyteDB release, such as the […]
Read MoreImplement Range Overlap Searches and EXCLUDE-Style Rules Without GiST
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 MoreUse 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 MoreCompare GFlag Defaults Across Versions Without Starting a Cluster
When preparing for a YugabyteDB upgrade or investigating a behavior change, a common question comes up: Did the default value of this […]
Read More