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 MoreCheck Grants on Removed PG11 Catalog Tables Before a PG15 Upgrade
When upgrading from a PostgreSQL 11-based YugabyteDB release to a PostgreSQL 15-based YugabyteDB release, the upgrade includes a PostgreSQL major-version upgrade phase. […]
Read More