A partial index can work perfectly when you test a query with literal values, yet disappear when the same query is executed […]
Read More
Fix pgcrypto Installed in pg_catalog Before a YugabyteDB v2024.2 to v2025.x Upgrade
Upgrading YugabyteDB from v2024.2 to v2025.2 includes a YSQL major-version upgrade from PostgreSQL 11 to PostgreSQL 15. YugabyteDB Anywhere runs a precheck […]
Read MoreAutomate YugabyteDB Release Downloads and Installations with Bash
Each YugabyteDB release page includes platform-specific wget commands for downloading the release tarball. The filename contains both the YugabyteDB version and a […]
Read MoreDiagnosing a Persistent pg_range Catalog Read in YugabyteDB
When tuning YSQL queries with EXPLAIN (ANALYZE, DIST), you will often notice that the first execution performs several catalog reads while later […]
Read More