Tiger Data, the innovative company behind TimescaleDB, has recently made significant strides in enhancing PostgreSQL’s capabilities for time-series data, real-time analytics, and AI applications. Their latest offering, pg_textsearch, is now available as an open-source extension, bringing modern search functionalities directly into the PostgreSQL ecosystem.
pg_textsearch Goes Open
Released under The PostgreSQL License on GitHub, pg_textsearch was previously exclusive to Tiger Cloud, their managed database platform. Michael Freedman, the CTO of Tiger Data, emphasized the extension’s value, stating:
If you care about fast, relevance-ranked keyword search without leaving Postgres – or hybrid retrieval by combining pg_textsearch with pgvector/pgvectorscale – this is for you.
With pg_textsearch, developers can execute BM25 relevance-ranked keyword searches directly within PostgreSQL, eliminating the need for external search systems like Elasticsearch. The BM25 algorithm, a cornerstone of modern search engines, can now be utilized seamlessly inside Postgres, facilitating relevance-ranked text searches. Furthermore, pg_textsearch integrates effortlessly with pgvector, enabling a powerful combination of keyword and semantic search within a single database.
For those seeking more insights, additional details can be found in a comprehensive blog post from Tiger Data.
Some of the notable features of pg_textsearch include:
- Support for 29+ languages.
- Compatibility with partitioned tables.
- Intuitive SQL syntax utilizing the
operator. - Memtable architecture for optimized indexing.
- BM25 ranking with adjustable parameters (k1, b).
Tiger Data envisions this release as the inaugural step toward developing a comprehensive Postgres Search Stack. This stack aims to cater to PostgreSQL developers, infrastructure engineers, and AI application creators by merging keyword search through pg_textsearch with vector search capabilities via pgvector and pgvectorscale, ultimately delivering a holistic search solution within the PostgreSQL environment.
Suggested Read 📖: Is SysAdmin Still a Good Career Choice in 2026?
