Tag

PostgreSQL

Tutorials, guides, and deep dives that cover PostgreSQL.

2 articles

AI & MLTutorial
Building a RAG Pipeline That Actually Works: Chunking, Embeddings, and Evaluation
Build a RAG pipeline that holds up in production: chunking strategies, embeddings in pgvector, hybrid search with RRF, reranking, citations, and evaluation.
Yahia RachekSep 30, 202616 min read
BackendDeep dive
Database Indexing Explained: How B-Tree Indexes Really Speed Up Your Queries
How PostgreSQL B-tree indexes work, how to read EXPLAIN plans, and how to design composite, covering, partial, and expression indexes that actually get used.
Yahia RachekAug 5, 202615 min read

Explore related topics