Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group