On Fri, Aug 24, 2018 at 2:01 AM, a <372660931(at)qq(dot)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