A pgvector fork with the performance of Pinecone
Hi friends, Excited to share our latest project, pgvector-remote, with you all! pgvector-remote is an extension designed to effortlessly incorporate remote vector stores, like Pinecone, into pgvector. With pgvector-remote, harnessing the power of a remote (Pinecone) index becomes as easy as utilizing ivfflat or hnsw. Why pgvector-remote? 1. Simplifies integration of memory-intensive vector indexes like Pinecone into standard database servers. 2. Addresses critical feature gaps in pgvector, such as metadata filtering for AI applications. 3. Hides the complexity of maintaining and…
In plain words
pgvector-remote is a PostgreSQL extension that integrates remote vector stores like Pinecone directly into pgvector. It enables developers to leverage remote vector indexes with the same simplicity as built-in pgvector methods while achieving sub-10ms latency and supporting metadata filtering. The extension combines Pinecone's performance characteristics with PostgreSQL's SQL compatibility and transaction support, eliminating the need for users to manage separate vector store infrastructure.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hi friends, Excited to share our latest project, pgvector-remote, with you all! pgvector-remote is an extension designed to effortlessly incorporate remote vector stores, like Pinecone, into pgvector. With pgvector-remote, harnessing the power of a remote (Pinecone) index becomes as easy as utilizing ivfflat or hnsw. Why pgvector-remote? 1. Simplifies integration of memory-intensive vector indexes like Pinecone into standard database servers. 2. Addresses critical feature gaps in pgvector, such as metadata filtering for AI applications. 3. Hides the complexity of maintaining and synchronizing vector stores from the user. Key Features: + Achieve <10ms latency and 200QPS throughput, similar to Pinecone. + Enjoy metadata filtering capabilities, just like Pinecone. + Benefit from SQL compatibility and transaction support akin to PostgreSQL. Usage: CREATE INDEX ON items USING PINECONE (embedding); We're continuously enhancing pgvector-remote and would love to hear your feedback!
More ai this month
the category →
I trained a 125M-parameter transformer to autocomplete piano performances in real time (~108 notes/sec on an iPhone 15). The idea is basically GitHub Copilot or Tabnine, except instead of prompting it with code, you prompt it by playing a few notes on a MIDI piano. The model then continues what you played, entirely on-device. The app is free if anyone wants to try it. Happy to answer questions about the model, training, Core ML, or the many things that didn't work.
AI · 17d ago · simedw.com
Astute▲585Automate your B2B brand going viral, with new media creators
AI · 18d ago · company-app.joinastute.com
Hey HN, Henry from Cactus here! We previously released Cactus Needle, a 14MB agentic LLM for tool call, device use, and structured extraction for phones, wearables, smart homes, small robots and microcontrollers. We got really great feedback here, and have now incorporated the suggestions to release Needle 2. The whole model is a single 14MB binary that runs a full session in 28MB of RAM; 45m parameters at 2bit compression. Needle hits 500 tokens/sec decode speed on a Raspberry Pi 5, sits between 400-1,500 tokens/sec on VR devices like Meta Quest 3S and Apple Vision Pro, and ranges…
AI · 26d ago · cactuscompute.com
Launched alongside, April 2024
the whole month →
Supabase▲2,328The Postgres developer platform is now generally available
Dev tools · 2024 · supabase.com
Cal.com Platform▲1,602Build your pixel-perfect booking experience with Atoms
Dev tools · 2024 · cal.com
deco.cx 2.0▲1,080Build web apps 10x faster with Deno, JSX, TS & Tailwind
Dev tools · 2024 · decocms.com
