PGRroonga¶

PGroonga is a specialized PostgreSQL extension that brings high-performance full-text search capabilities directly into the database. Unlike the native tsvector or GIN indexes, PGroonga is built on the Groonga storage engine, allowing it to handle extremely fast searches across all languages—including complex CJK (Chinese, Japanese, Korean) scripts—without needing external search engines like Elasticsearch.

The real power of PGroonga lies in its ability to perform instant “as-you-type” searches and complex filtering on massive text columns, JSONB data, and even arrays. It supports advanced features like multilingual tokenisation, fuzzy matching, and BM25 ranking, all while maintaining the ACID compliance and transactional integrity of a standard PostgreSQL table. This makes it the ideal choice for building responsive, high-scale search interfaces where data consistency is non-negotiable.

PGroonga makes PostgreSQL fast full text search platform for all languages!