alanwli

4 ms·

1. 1.▲
   by alanwli 8mo ago

   Out of curiosity, how is the 92% recall calculated? For a given query, is the recall compared to the true topk of all 100B vectors vs. recall at each of N shards compared to the topk of each respective shard?
2. 2.▲
   by alanwli 11mo ago

   I've seen a decent amount of production use of pgvector HNSW from our customers on GCP, but as the author noted is not without some flaws and are typically in the smallish range (0-10M vectors) for the systems characteristics that he p
3. 3.▲
   by alanwli 1y ago

   The alternative is to find solutions that can reasonably support different requirements because business needs change all the time especially in the current state of our industry. From what I’ve seen, OSS Postgres/pgvector can adequat
4. 4.▲
   by alanwli 2y ago

   Nice! I've seen other extensions that don't have transactional semantics, which runs counter to the norm for PG. So since it was previously weakly consistent due to performance reasons, how does strong consistency affect transacti
5. 5.▲
   by alanwli 2y ago

   Always great to see Postgres-based alternatives. One clarification question - the blog post lists "lack of ACID transactions and MVCC can lead to data inconsistencies and loss, while its lack of relational properties and real-time cons