The Case Against pgvector | Alex Jacobs
What happens when you try to run pgvector in production and discover all the things the blog posts conveniently forgot to mention
Summary
**pg_textsearch** is a PostgreSQL extension implementing BM25 relevance-ranked full-text search using the `<@>` operator and `bm25` indexes with configurable k1 and b parameters.
It supports PostgreSQL 17 and 18, multiple text configurations like English and French, partitioned tables, and automatic index maintenance. Currently at v0.1.1-dev prerelease with in-memory memtable architecture, it is not recommended for production.