Postgres Pro
Downloads
Home   >   mailing lists

Re: efficient math vector operations on arrays - Mailing list pgsql-general

From Pavel Stehule
Subject Re: efficient math vector operations on arrays
Date
Msg-id CAFj8pRD-Ln_8+qjf9s2Y6+1OpRxje0hDR_TtiF-X9vaBg7OGeQ@mail.gmail.com
Whole thread Raw
In response to efficient math vector operations on arrays  (Marcus Engene <mengpg2@engene.se>)
Responses Re: efficient math vector operations on arrays  (Marcus Engene <mengpg2@engene.se>)
List pgsql-general
Tree view
Hi

2015-12-24 8:05 GMT+01:00 Marcus Engene <mengpg2@engene.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.

Regards

Pavel

 

Kind regards,
Marcus



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Marcus Engene
Date:
Subject: efficient math vector operations on arrays
Next
From: Marcus Engene
Date:
Subject: Re: efficient math vector operations on arrays