Xiaoran Wang

@microsoft-github-policy-service agree [company="{your company}"]

@microsoft-github-policy-service agree

@jkatz I found a page that proposed some methods to deal with `attribute filter ` https://www.cs.purdue.edu/homes/csjgwang/pubs/SIGMOD21_Milvus.pdf I just have a rough idea: If there is any index on the attribute,...

@jkatz Your approach of creating multiple columns index to support attribute filtering looks good to me. >Finally, in the case we have a category_id present, I wonder if we can...

That's interesting, could you try bigger ivfflat.probes or a different vector here`(embedding %s)` to see if it can return any results?

@vincenzon I guess I know the cause, I reproduced it by the following steps ``` create table t5(id int, embedding vector(3)); insert into t5 values(1, '[1,3,5]'); insert into t5 values(2,...

@vincenzon Yes, I know what you mean. You expect the index scan to return the same result as the seq scan. Looks like this issue is similar to https://github.com/pgvector/pgvector/issues/259.