Re: C Function with Arrays Question

From: Rnd(at)gatewaynet(dot)com
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: C Function with Arrays Question
Date: 2002-03-27 07:37:27
Message-ID: OF96257087.77CB3A84-ONC2256B89.00290F77@internal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Denis Gasparin 2002-03-27 08:11:06 Re: Altering a CHAR(4) column CHAR(5) changing
Previous Message Medi Montaseri 2002-03-27 07:06:50 Re: Test data sets