2 ms·
This page has a fairly helpful breakdown of the various types of indexes available, but from what I can tell it doesn’t explicitly mention the correctness trade
by basil-rash 3y ago
This page has a fairly helpful breakdown of the various types of indexes available, but from what I can tell it doesn’t explicitly mention the correctness trade offs made when using an index vs a pure table scan. I know in pgvector HNSW for instance is inexact. But it doesn’t really matter in a RAG context - even the embeddings themselves are stochastic.
https://myscale.com/blog/everything-about-vector-indexing/ https://myscale.com/blog/everything-about-vector-indexing/
- nrjames 3y agoI'm not sure how much of the underlying Clickhouse feature set is available, but the Clickhouse documentation about index types is thorough and informative. https://clickhouse.com/docs/en/optimize/sparse-primary-indexes https://clickhouse.com/docs/en/optimize/sparse-primary-index...