pgvector
AssessTools
A PostgreSQL extension for storing and querying vector embeddings.
Why it's here
Placed in Assess: 2 article(s) of evidence from 1 source(s), led by open-source activity, with 1 in the last 30 days. Confidence 33%.
Evidence (2)
- 7Hacker News·8/5/2026researchCastform claims 100x cheaper retrieval than GPT-5.6 Sol
Castform says its 4B open-source model, post-trained with RL, can retrieve search results as accurately as GPT-5.6 Sol while costing about 100x less. The company pairs its model training pipeline with Neon’s Lakebase Search and Postgres-based storage to support both training and inference.
- 4Hacker News·7/6/2026open_sourceWhy some teams can stay on Postgres
The article argues that many applications add Redis, Elasticsearch, Kafka, MongoDB, and other systems before proving Postgres is insufficient. It recommends using Postgres features such as JSONB, tsvector, SKIP LOCKED, pgvector, and PostGIS first, and adding specialized infrastructure only when the operational tradeoff is justified.