Blog
PostgreSQL, pgvector, and AI infrastructure: guides and deep dives.
Filter by tag
All posts
Building a Production RAG Stack on PostgreSQL
The full RAG pipeline on PostgreSQL and pgvector: schema, chunking strategy, hybrid search with RRF in working SQL, reranking, the ef_search recall tradeoff, and an honest end-to-end latency budget. Plus where one-database RAG runs out of road.
11 min read
What Is pgvector? A Practitioner's Introduction
What pgvector actually adds to PostgreSQL (the vector type, distance operators, and HNSW indexing) plus a real end-to-end example, honest scale limits, and the operational gotchas (index build memory, ef_search, PgBouncer) nobody warns you about.
11 min read
LlamaIndex + pgvector: Production RAG on Postgres
A production-shaped LlamaIndex RAG pipeline on pgvector: ingestion, metadata filtering, multi-document retrieval, and the settings that matter at scale.
10 min read
Building a RAG Application with pgvector and the OpenAI API
Build a production-ready RAG pipeline using pgvector and OpenAI embeddings, without LangChain. Covers chunking, embedding, storing vectors in PostgreSQL, retrieval, and answer generation with full Python code.
10 min read
pgvector + Node.js: Semantic Search, Complete Code (2026)
Store and query embeddings from Node.js: node-postgres and Drizzle setups, OpenAI embeddings, HNSW indexing, and a full RAG pipeline you can run today.
12 min read
pgvector Hybrid Search: a Working Example (RRF + FTS)
Combine pgvector and Postgres full-text search with reciprocal rank fusion. Copy-paste SQL, scoring that holds up, and the production traps to avoid.
10 min read
Best Managed pgvector Hosting (2026): 8 Providers Compared
Rivestack, Supabase, Neon, Aiven, AWS, Google Cloud, Exoscale, and Elestio compared on HNSW tuning, storage, migration help, and monthly cost.
10 min read
Elestio pgvector Alternative: Comparing Marketplace Hosting with Focused Managed PostgreSQL
Compare Elestio managed pgvector with Rivestack for production vector search workloads, including infrastructure, tuning, pricing, and migration support.
6 min read
Exoscale pgvector Alternative: Comparing European Managed pgvector Providers
Compare Exoscale managed pgvector with Rivestack for European teams running production RAG, semantic search, and vector-heavy PostgreSQL workloads.
6 min read