Five read-only PostgreSQL queries that find the usual causes of a production slowdown: lock chains, idle transactions, connection exhaustion, unindexed foreign keys and integer IDs running out.
Our search endpoints are hitting URL length limits with GET, and POST lies about semantics. The HTTP QUERY method finally offers both a request body and safe, read-only semantics.
Lessons from shipping a production RAG pipeline — chunking strategies, retrieval quality, cost control, and why your eval suite matters more than your vector database.