General Question Re. Compound Vector Indexes

[rsomani95]

Hi, this may be a bit of a silly question, but I'm very curious to hear your take on it: is it even feasible to have compound indexes with a vector index?

Concretely, I have two fields in my table called embedding and category. I almost always filter on category when using embedding to do vector search, and so theoretically having a compound index should help. Also curious if your answer would change if category has a fixed range of values vs. an arbitrary string.

Thanks!

[cevian]

We do plan to look at compound indexes in the future. But, for categorical variables you also have the option of using partial indexing and/or partitioning the table by category. For smooth variables, neither of those is possible though.