turbopuffer's "RIP, vector database" post sent me to look at our own notebook search.One pgvector HNSW index over every team's chunks, team and notebook filtered in the WHERE, iterative index scans never turned on. pgvector's README says the filter runs after the scan: a condition matching 10% of rows returns about 4 results at the default ef_search of 40.There's a btree on team_id the planner may prefer. Haven't read the prod plan yet.#Postgres #MachineLearning #SoftwareEngineering
turbopuffer's "RIP, vector database" post sent me to look at our own notebook search.One pgvector HNSW index over every ...
