-Original Message-
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
ow...@postgresql.org] On Behalf Of Pavel Stehule
Sent: Dienstag, 13. Dezember 2011 15:43
To: Aleksej Trofimov
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgres array parser
Hello
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgres array parser
Hello
2011/12/13 Aleksej Trofimovaleksej.trofi...@ruptela.lt:
We have tried foreach syntax, but we have noticed performance
degradation:
Function with for: 203ms
Function with foreach: ~250ms:
there is functions
Sent: Dienstag, 13. Dezember 2011 15:43
To: Aleksej Trofimov
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgres array parser
Hello
2011/12/13 Aleksej Trofimovaleksej.trofi...@ruptela.lt:
We have tried foreach syntax, but we have noticed performance
degradation
Hello, I wanted to ask according such a problem which we had faced with.
We are widely using postgres arrays like key-value array by doing like
this:
{{1,5},{2,6},{3,7}}
where 1,2,3 are keys, and 5,6,7 are values. In our pgSql functions we
are using self written array_input(array::numeric[],
Hello
do you know FOREACH IN ARRAY statement in 9.1
this significantly accelerate iteration over array
http://www.depesz.com/index.php/2011/03/07/waiting-for-9-1-foreach-in-array/
2011/12/13 Aleksej Trofimov aleksej.trofi...@ruptela.lt:
Hello, I wanted to ask according such a problem which
We have tried foreach syntax, but we have noticed performance degradation:
Function with for: 203ms
Function with foreach: ~250ms:
there is functions code:
CREATE OR REPLACE FUNCTION input_value_fe(in_inputs numeric[],
in_input_nr numeric)
RETURNS numeric AS
$BODY$
declare i numeric[];
BEGIN
Hello
2011/12/13 Aleksej Trofimov aleksej.trofi...@ruptela.lt:
We have tried foreach syntax, but we have noticed performance degradation:
Function with for: 203ms
Function with foreach: ~250ms:
there is functions code:
CREATE OR REPLACE FUNCTION input_value_fe(in_inputs numeric[],