Feature Request: Add Sum Aggregation and Column-Wise Multiplication for Sparse Vectors about pgvecto.rs HOT 4 OPEN

Understand! PRs on the way

from pgvecto.rs.

Thanks for your interest! May I ask what's your scenario to do the aggregate sum for sparse vectors? What's the query looks like?

from pgvecto.rs.

And what's Column-Wise Multiplication? Do you mean dot product between sparse vectors?

from pgvecto.rs.

Thanks for your interest! May I ask what's your scenario to do the aggregate sum for sparse vectors? What's the query looks like?

We utilize a sparse vector as a bag-of-words representation for a set of documents. In this representation, each dimension in the sparse vector denotes a term, while the value indicates its frequency within a given document. By using the sum aggregation, we would be able to easily compute some statistics about the collection.
For example
select sum(term_frequencies) from documents;
would result in the total term frequencies for each term.

And what's Column-Wise Multiplication? Do you mean dot product between sparse vectors?

My bad, I meant element-wise multiplication, not column-wise.
For example [1, 2, 3] * [1, 2, 3] = [1, 4, 9] (for both dense and sparse vectors)

from pgvecto.rs.