pg_pinecone

provides a rerank() function that reorders retrieved passages with a Pinecone model

“rerank() herschikt gevonden passages met een Pinecone-model.”

provides BM25 search for exact words alongside semantic search

“BM25 zoekt op exacte woorden naast zoeken op betekenis.”

provides an embed() function that creates vectors from text via Pinecone's inference service

“embed() maakt vectoren vanuit tekst via Pinecone's inference-service.”

requires PostgreSQL 17 or 18, superuser privileges, and pgvector for installation

“Installatie vraagt PostgreSQL 17 of 18, superuserrechten en pgvector.”

supports three engines that search within PostgreSQL or use a remote Pinecone index

“Per tabel kan de beheerder kiezen uit drie engines.”