Introducing pg_pinecone: Open-Source Search for Your Postgres Data
Blog post from Pinecone
Pinecone has introduced pg_pinecone, an Apache 2.0 open-source PostgreSQL extension that adds vector search to existing pgvector data while keeping tables and full vectors in Postgres. Its native engine uses IVF clustering and RaBitQ vector compression rather than an HNSW graph, aiming to reduce index size, accelerate index construction and search, and improve filtered-query accuracy by applying filters during search instead of afterward. The extension preserves standard SQL vector queries and lets users switch among its local native engine, pgvector’s HNSW index, and Pinecone’s managed remote service without changing queries. Reported benchmarks on one million 768-dimensional vectors show smaller indexes and lower latency at comparable recall than HNSW, particularly for narrow filters, although substantial data changes may require reindexing or automatic maintenance. Optional Pinecone-connected features include embedding text through SQL, BM25 full-text search, reranking, and scaling search beyond a single database server, while Pinecone invites community feedback and contributions for the project’s future development.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Vector Search | 12 | 1,979 | 416 | 136 | +18% |
| RAG | 1 | 874 | 224 | 84 | +1% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.