Notes

Writing on AI, ML systems, and software engineering.

RAG

PostgreSQL

pgvector

How to use metadata filters to scope vector similarity search — and why filtering before retrieval beats filtering after.

PostgreSQL

pgvector

Database

When to use HNSW and when to use IVFFlat for vector similarity search in PostgreSQL — and what the tradeoffs actually mean in practice.

PostgreSQL

Database

Patterns for structuring PostgreSQL schemas when your app involves embeddings, vector search, and LLM-generated content.