pgvector

DevOps

PostgreSQL pgvector Performance Tuning for RAG: Indexes and Query Plans

A practical guide to pgvector performance tuning with architecture, implementation, verification, security and production operations.

LLMs

Vector Database vs PostgreSQL pgvector: Choosing With Benchmarks

Practical guide to pgvector vs vector database: architecture, examples, setup, testing, troubleshooting and production best practices.

Python

Build a RAG Chatbot With Python, FastAPI and pgvector: Step-by-Step Tutorial

Build a RAG chatbot with Python, FastAPI and PostgreSQL pgvector. Learn ingestion, embeddings, secure retrieval, grounded answers and testing.