Re: Strange plpgsql performance, diff plperl and plpgsql

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange plpgsql performance, diff plperl and plpgsql
Date: 2005-04-03 23:46:06
Message-ID: Pine.LNX.4.44.0504040138340.13204-100000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I found different behavior of array inicialised from plperl than plpgsql.
I use code from my prev. mail

tarif=# select speed(10);
speed
-----------------------
{0,1,2,3,4,5,6,7,8,9}
(1 row)

Time: 2,304 ms
tarif=# select speed2(10);
speed2
------------------------------------------------------
{1.00,2.00,3.00,4.00,5.00,6.00,7.00,8.00,9.00,10.00}
(1 row)

Time: 0,863 ms

the array from speed2 is ok, but array from speed is mal formated.
I declare all function as numeric(7,2)[]

when I change init value on 0.01, than results are equal

regards
Pavel Stehule

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-04-04 00:41:51 Re: [HACKERS] plPHP in core?
Previous Message Pavel Stehule 2005-04-03 22:59:51 Re: Strange plpgsql performance -- arithmetic, numeric()