Re: C Function with Arrays Question - Mailing list pgsql-general

From Rnd@gatewaynet.com
Subject Re: C Function with Arrays Question
Date
Msg-id OF96257087.77CB3A84-ONC2256B89.00290F77@internal.net
Whole thread Raw
In response to C Function with Arrays Question  (Achilleus Mantzios <rnd@gatewaynet.com>)
List pgsql-general

Dear Tom,

regarding the question i posted, after tests and benchmarks,
i found that retreiving the _float8 array from JDBC and doing the
calculations
in java is faster than calling a C function that performs the same
calculation
on the same _float8 array and returns float8.
In the C function there were no DB calls or any other I/O calls but plain
arithmetic,
so i declared it iscached and the benchmark loop run 1000,10000 times and
so on.
I was surprised by the result!
I am running pgsql 7.2 on a linux 2.4.7, glibc 2.2.2


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Suggestion for table/index structure?
Next
From: Denis Gasparin
Date:
Subject: Re: Altering a CHAR(4) column CHAR(5) changing