The pg_search extension

pg_search was deprecated for new Neon projects on March 19, 2026. If you used pg_search the extension was retired from existing projects on September 21, 2026. Its replacement for BM25 search on Neon ...

The pg_search extension by ParadeDB added BM25 full-text search to Postgres, using inverted indexes and the @@@ operator to run keyword, phrase, fuzzy, and faceted search through SQL and a JSON query DSL. It's no longer available on Neon.

To replace pg_search with lakebase_text on Neon, see Migrate from pg_search to lakebase_text. For the full pg_search feature reference, see the ParadeDB documentation.

Need help?

Join our Discord Server to ask questions or see what others are doing with Neon. For paid plan support options, see Support.