4d ago · 6 min read · I sat down to write the pgvector section of this post—the HNSW index DDL, the reranker batching, the metadata filter shapes—and realized I kept reaching for the wrong file. The query I was proud of wasn’t the vector search. It was dedupeRagChunks. Th...
Join discussion5d ago · 8 min read · The $340 invoice showed up on a Tuesday in late January. Not wild money in isolation, but this was for an internal RAG tool serving exactly 11 people — my team at a fintech startup — and when I did the math, that was $30 per user per month for what a...
Join discussionMar 3 · 7 min read · Essential PostgreSQL Extensions Every Developer Should Know PostgreSQL's extension system is one of its greatest strengths. Extensions let you add capabilities that would require switching databases entirely in other ecosystems. This guide covers the...
Join discussionFeb 2 · 13 min read · The PostgreSQL Paradox Here's something that sounds like a contradiction: the most popular database in the world is also the most underutilized. If you're building something new in 2024, you're probably using PostgreSQL. Stack Overflow's developer su...
Join discussion
Dec 3, 2025 · 13 min read · 1. Introduction In the past few months, we’ve heard consistent feedback from users and partners: while our goal of providing a scalable, high-performance alternative to pgvector is well-received, index build time and memory usage remain major concern...
Join discussionSep 20, 2025 · 5 min read · Building a RAG application is currently a popular topic, and one key requirement is a vector store or database to store and query embeddings. While there are specialized vector databases available, we can also use the OG PostgreSQL as a vector databa...
Join discussion
Jun 5, 2025 · 4 min read · We're excited to announce the release of VectorChord 0.4, a significant update that enhances high-performance vector search within PostgreSQL. We believe this release pushes the boundaries of what's possible for vector search in PostgreSQL, introduci...
Join discussion
May 31, 2025 · 8 min read · Hi everyone — especially those who’ve been eagerly waiting for my series, and particularly all the JavaScript developers out there. How’s your day going in this booming age of AI? 🚀 AI is growing at an incredible pace. Haven’t started yet? Feeling o...
Join discussion
Apr 3, 2025 · 11 min read · Introduction: real-world challenges Specialized vector databases aren’t always needed. With PostgreSQL extensions like pgvector, pgvectorscale, VectorChord (which evolved from pgvecto.rs), you get vector search plus relational power—no extra infras...
Join discussion
Apr 2, 2025 · 6 min read · You might have come across discussions or blog posts suggesting that PostgreSQL's built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon's bl...
Join discussion