Aggregate functions for vectors

[mmcauliffe]

I'm trying to generate means of vectors, but I'm getting the error message ERROR: function avg(vector) does not exist. Is this something that's easy to implement in pgvector, or should I rely on code outside the database for aggregation?

[ankane]

Hi @mmcauliffe, you'll currently need to rely on outside code. Can you share more about the use case?

[ankane]

Previous discussion: #13

[mmcauliffe]

So I'm working with ivectors for speaker recognition with databases of speech corpora, The database has a table for utterances with audio data, along with a table of speakers of those utterances. Ivectors are calculated initially over utterances, and then the ivector for a speaker is the mean of the utterance ivectors. In the application, I'm using for running classification of "did this speaker actually speak this utterance?" and comparing between speakers for "is the metadata wrong and these should actually be treated as the same speaker" to clean up the speech corpus with better metadata.

Not too huge of a deal to do a query, aggregate, and update, but it'd be nice to have the speaker ivector be a function of the utterance ivectors inside the database so that speakers get updated more automatically.

[ankane]

Thanks for the context. Added in the commit above (and will be released with 0.4.0, likely sometime in January).