Cloud SQL for PostgreSQL Adds `pg_textsearch` Extension for Full-Text Search
Cloud SQL for PostgreSQL now supports the `pg_textsearch` extension, enabling robust full-text search capabilities. This enhancement utilizes the industry-standard BM25 scoring algorithm, offering highly accurate relevance for search results. To use this functionality, users must have PostgreSQL 17 or later, along with Cloud SQL release R20260712.01_06 or later. This benefits developers and architects needing advanced text search within their PostgreSQL databases on GCP.
Features (1) ›
- Cloud SQL for PostgreSQL
You can use the pg_textsearch extension in Cloud SQL for PostgreSQL to perform full-text search using the industry-standard BM25 (Best Matching 25) scoring algorithm for highly accurate relevance scoring. This extension requires PostgreSQL 17 or later and is supported on PostgreSQL release R20260712.01_06 or later. For more information, see Full-text search using pg_textsearch .
https://docs.cloud.google.com/release-notes#September_14_2026
Related releases
- Cloud SQL for SQL Server 2017 Deprecation and End-of-Life Announced Google Cloud release notes ·
- Cloud SQL for PostgreSQL: sqlcommenter tags temporarily disabled on remote MCP Google Cloud release notes ·
- Cloud SQL for MySQL: sqlcommenter Tag Appending Temporarily Disabled Google Cloud release notes ·
- Cloud SDK 584.0.0: Breaking Changes, Deprecations, and Security Update Google Cloud release notes ·
- Bridging the SQL Server Login Gap in Cloud SQL Migrations Google Cloud Blog ·
- Cloud SQL for PostgreSQL Admin API adds regional endpoints for GA Google Cloud release notes ·