A month ago, during a release to production, the feature I was working on failed to deploy due to a PostgreSQL restriction. It turned out to be a surprisingly fun and comprehensive learning moment.

An issue I often see folks missing when reviewing query plans, is that they see that all of their scans involve indexes and they think that the query is likely already as fast (or efficient) as it can be. In this post we’ll look through several examples, some things to look out for, and how to then

Learn the theory and the details of how to speed up PostgreSQL® pgvector queries using indexes IVFFlat, HNSW and traditional indexes

It’s important to understand basics of indexing and best practices around them for preventing system downtime.