select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Full-text search

pg_search

Full text search for PostgreSQL using BM25

pgext.cloud · Source code · Website · Documentation · License text · Control file · PGXN

Overview

Packagepg_search
Version0.25.9
PostgreSQL versions15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Project statusActive
VendorParadeDB
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_search
Schemaparadedb
Stars9,213
Latest commit2026-08-28
Latest release2026-08-27
Catalogue updated2026-09-19

Related extensions

Requires

vectorvector data type and ivfflat and hnsw access methods

See also

pg_textsearchFull-text search with BM25 ranking
pg_bestmatchGenerate BM25 sparse vector inside PostgreSQL
vchord_bm25A postgresql extension for bm25 ranking algorithm
pg_ftsFull-text search with BM25 and BM25F ranking
pgroongaUse Groonga as index, fast full text search platform for all languages!
pg_rrfReciprocal rank fusion functions for hybrid search
psql_bm25sPostgreSQL extension for BM25-family lexical retrieval
pgcontextVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
vectorizeThe simplest way to do vector search on Postgres
pgfacetingfast faceting queries using an inverted index
roaringbitmapsupport for Roaring Bitmaps
rumRUM index access method