Backend Engineering
Backend Engineering••12 min read
Postgres EXPLAIN Cheat Sheet: Reading Query Plans Like a Pro
Postgres EXPLAIN plans: node types, cost interpretation, and six query anti-patterns to avoid.
BackendBytes Engineering Team
Read
#PostgreSQL
PostgreSQL internals, advanced querying, indexes, and production tuning.
6 Articles
Articles
AI Engineering
AI Engineering••17 min read
Vector Databases Compared: pgvector vs Pinecone vs Weaviate
Compare pgvector, Pinecone, Weaviate and Milvus (plus Qdrant and LanceDB briefly) on operational fit, scaling and pricing — with real code and each vendor's own documentation.
BackendBytes Engineering Team
Read
AI Engineering
AI Engineering••17 min read
Building Production RAG Pipelines: Chunking, Embeddings, and Retrieval at Scale
Build RAG systems that work in production: chunking strategies, embedding selection, pgvector ops, and retrieval quality evaluation.
BackendBytes Engineering Team
Read
Backend Engineering
Backend Engineering••14 min read
Database Indexing Strategies: B-Trees, GIN, GiST, and Production Tuning
B-tree internals, composite index ordering, GIN for full-text search, partial indexes, and preventing index bloat in production.
BackendBytes Engineering Team
Read
Backend Engineering
Backend Engineering••14 min read
PostgreSQL Query Planner Internals: From EXPLAIN to Expert Tuning
How PostgreSQL's query optimizer decides, why it gets it wrong, and how to fix it with statistics targets and covering indexes.
BackendBytes Engineering Team
Read
Backend Engineering
Backend Engineering••15 min read
Zero-Downtime Database Migrations at Scale
Schema migrations on billion-row tables without downtime: expand-contract, pg_repack, gh-ost, blue-green migrations, and rollbacks.
BackendBytes Engineering Team
Read