Joel Reymont <joe...@gmail.com> writes:
> On Apr 26, 2011, at 5:00 PM, Tom Lane wrote:
>> For another couple orders of magnitude, convert the sub-function to C code.  
>> (I don't think you need
>> a whole data type, just a function that does the scalar product.)

> That's a 30x speedup, from 12 minutes down to 38s. Thanks Tom!

Huh, I would've bet on a lot more actually.  The nodeFunctionscan and
nodeAgg code must not be as inefficient as it looks on the surface ...

                        regards, tom lane

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

Reply via email to