On Fri, Aug 24, 2018 at 2:01 AM, a <372660...@qq.com> wrote:
>
> Say if I have an float8 array:
>
> id| data
> --|---------------
> a | {1,2}
> b | {2,4}
>
> . . .
>
> Since I would have around 200,000 rows, I would prefer it having enough
> capacity to carry out the calculation such as sum().Is this something that would help you?: https://github.com/pjungwir/aggs_for_vecs (also on pgxn: https://pgxn.org/dist/aggs_for_vecs) It would let you say `SELECT vec_to_sum(data)` and get `{3,6}`. Paul
