When Your pgvector Search Quietly Gets Worse — Field Notes on Protecting Recall with Gemini Embeddings
A semantic search built on Gemini Embeddings and PostgreSQL pgvector tends to lose precision over months without throwing a single error. These are field notes on the real causes — model pinning, operator/index mismatch, HNSW reindexing, and recall collapse under filters — with working code.
Gemini API × PostgreSQL Complete Implementation Guide — Building an AI-Driven Database Optimization System for Production
A complete production-ready guide to automating PostgreSQL optimization with Gemini 2.5 Pro — covering Text-to-SQL generation, EXPLAIN plan analysis, index recommendations, and schema reviews using Python and FastAPI.