Query-optimization

2 articles

PostgreSQL Performance Tuning — From Slow Queries to Sub-Millisecond Responses

Identify slow queries with pg_stat_statements, read EXPLAIN ANALYZE output, tune work_mem and autovacuum, and configure PgBouncer for connection pooling.

March 15, 2026Read →

RAG11 min read

Query Understanding for RAG — Rewriting, Expansion, and Decomposition

Transform user queries to improve retrieval with rewriting, HyDE, step-back prompting, and multi-hop decomposition techniques that boost RAG accuracy.

March 15, 2026Read →