pg_textsearch
Fewer than 5 people recommend it so far, so there's no written verdict. Here is what commenters said.
Why people recommend it
“been shipping it for a while”
“we have been using pg_textsearch in production for a few weeks now, and it's been fairly stable and super speedy”
Show 1 more
“with the recent example of pg_textsearch (BM25)”
Caveats and dissent
No one in these comments warned against it.
Often compared with
From the makers not counted in the ranking
“We have an alternative full-text search extension as well, pg_textsearch that's completely open source”
“you can use https://github.com/timescale/pg_textsearch on Azure HorizonDB”
“we've got pretty robust partitioned table support in the extension”
“pg_textsearch v1.0 is freely available via open source (Postgres license)”
“We have docs on how to do hybrid search here”
“these two extensions make postgres a really capable hybrid search engine”
Threads where it came up
- Show HN: How This Graybeard Built the Fastest and Freest Postgres BM25 Search 5 mentions
- Postgres extension complements pgvector for performance and scale 2 mentions
- Pg_vectorsearch: An index that is faster than pgvector's IVFFlat and HNSW 1 mention
- Tin: full-text search for Postgres 1 mention
- pg_durable: Microsoft open sources in-database durable execution 1 mention
- In 2026, Postgres Is (Still) Enough 1 mention
Data: pg-textsearch.json. Quotes are verbatim; the verdict and theme labels are written by a model from these comments, and every clause links to its sources.
All comments 6
“Timescale has pg_textsearch”
“been shipping it for a while”
“https://timescale.github.io/pg_textsearch/benchmarks/comparison.html”
“we have been using pg_textsearch in production for a few weeks now, and it's been fairly stable and super speedy”
“with the recent example of pg_textsearch (BM25)”
“BM25 index for postgres, mostly written by a single (very smart) guy and Claude Code.”