| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Marcus Engene <mengpg2(at)engene(dot)se> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: efficient math vector operations on arrays |
| Date: | 2015-12-24 07:13:42 |
| Message-ID: | CAFj8pRD-Ln_8+qjf9s2Y6+1OpRxje0hDR_TtiF-X9vaBg7OGeQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
2015-12-24 8:05 GMT+01:00 Marcus Engene <mengpg2(at)engene(dot)se>:
> Hi,
>
> Are there highly efficient C extensions out there for math operations on
> arrays? Dot product and whatnot.
>
what you mean "highly efficient" ?
PostgreSQL executor is interpret - so in almost all cases the special
optimizations has not big sense. If you take few us, you will lost in
executor.
>
> Example usecase: sort an item by euclid distance.
>
some is in intarray http://www.postgresql.org/docs/9.4/static/intarray.html
Regards
Pavel
>
> Kind regards,
> Marcus
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcus Engene | 2015-12-24 07:34:22 | Re: efficient math vector operations on arrays |
| Previous Message | Marcus Engene | 2015-12-24 07:05:00 | efficient math vector operations on arrays |