Pg_sorted_heap–Physically sorted PostgreSQL with builtin vector search
Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.
Want to reach these readers? Sponsor an issue.
HN · launched Mar 6, 2026 · 10 upvotes (top 42%) · 0 views
Niche: database management systems and engines · 162 launches, 5 in the last 7 days ▼ -17% · Explore this niche →
Category and tags
- Horizontal
- Data infrastructure
- Developer
- AI feature
- Hobby / open-source project
Visit website ↗ Source listing ↗
More like this: all 162 launches in database management systems and engines →
Could you build this?
No Implementing a custom C-based PostgreSQL storage engine extension that alters table heap storage layout and integrates low-level vector indexing requires deep PostgreSQL internals and C systems programming knowledge.
What it would actually take: Requires deep C systems programming and mastery of PostgreSQL internal table access method (TAM) APIs, buffer management, WAL logging, and index-scan mechanics. The builder must write memory-safe C extensions that interface with SIMD-accelerated vector search libraries (like FAISS or USearch) while ensuring crash recovery and ACID compliance.
Discussion
1 comment analyzed.
Competitors mentioned: pgvector with HNSW index, pgvector IVFFlat index
Concerns raised: 22ms latency vs 14ms for HNSW (slower vector search), Limited to PostgreSQL 17+18 (version compatibility), IVF-PQ quantization bottleneck vs storage precision gains
Competitors
Other products that read as similar to this one : 1090 launches clear the similarity bar, closest 8 shown.
Attention rank: #446 of 1091 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 128 days after the earliest competitor.
- Pgcraft · hn · 2026-05-26 · 6 upvotes · similarity 0.61
- Pgsemantic · hn · 2026-03-25 · 18 upvotes · similarity 0.60
- jevql · github · 2026-09-18 · 11 upvotes · similarity 0.60
- SortVisualizer · github · 2026-09-27 · 9 upvotes · similarity 0.59
- kividb · github · 2026-10-16 · 316 upvotes · similarity 0.59
- Asynchronous text chunking and vector embedding generation in Postgres · hn · 2025-12-19 · 5 upvotes · similarity 0.58
- pgfake · github · 2026-10-06 · 33 upvotes · similarity 0.55
- pgsync · github · 2026-10-13 · 90 upvotes · similarity 0.55
The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.