Do i need to store all filters in the "metadata" column? about vecs HOT 1 CLOSED

vecs automatically indexes your metadata when you run Collection.create_index(...). Internally that metadata is stored as a jsonb column.

If you query based on equality e.g.

docs.query(
    ...
    filters={"user_id": {"$eq": 99}},
)

then the filter will be able to use the index and the performance difference will be negligible when compared to a dedicated column.

In the future we may offer the ability to create dedicated columns to allow cleaner interop with other parts of postgres e.g. e.g. referential integrity with foreign keys, but performance is not likely to be a motivator in real-world workloads

from vecs.