Topic

Vector Databases

6 articles on Vector Databases, written from production systems rather than documentation.

3 min read

Choosing a vector database on the constraints that bind

Benchmarks compare query speed at a scale you may never reach. Filtering, tenancy and how updates behave decide more of the outcome than throughput.

AIVector DatabasesDatabasesArchitecture
Read post
3 min read

Do you actually need a vector database yet

Below a few hundred thousand vectors, a dedicated database mostly adds a system to operate. The threshold is higher than the tooling implies.

AIVector DatabasesRAGArchitecture
Read post
3 min read

How vector indexes trade accuracy for speed

Approximate search is approximate on purpose. Knowing which results you are giving up explains retrieval failures that look like model problems.

AIVector DatabasesPerformanceDatabases
Read post
3 min read

Metadata filtering is where vector search meets reality

Real queries are never purely semantic. They are scoped to a tenant, a status and a date, and where that filter runs changes the results you get.

AIVector DatabasesRAGArchitecture
Read post
3 min read

When Postgres is already the vector database you need

Storing embeddings beside the rows they describe removes a sync problem and makes filtering a join. That is worth more than raw index throughput.

AIVector DatabasesDatabasesRAG
Read post
3 min read

What running vector search at scale actually costs

Approximate indexes want to be in memory, and memory is the bill. Sizing that before you commit is the difference between a plan and a surprise.

AIVector DatabasesPerformanceDatabases
Read post

Have a system to build?

Whether it needs designing from scratch or rescuing from its own success, tell me what you’re building and I’ll tell you how I’d architect it.

Open to remote and hybrid work worldwide