Sells in this field
pg_pinecone: Under the hood of vector search in Postgres
Vector search inside Postgres is handled by the pg_pinecone extension, which Jörg Schad of Pinecone describes, including how filtering undermines HNSW indexes and how a smaller index keeps memory use down.