Tom Lane wrote:
>
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Is it normal that a query that takes <1 sec when executed from psql
> > prompt takes > 15 sek when executed from a function
>
> No. I can't reproduce the quoted misbehavior under either 7.0.2 or
> current sources; your example ta
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Is it normal that a query that takes <1 sec when executed from psql
> prompt takes > 15 sek when executed from a function
No. I can't reproduce the quoted misbehavior under either 7.0.2 or
current sources; your example takes ~1 sec either way for me.
Is it normal that a query that takes <1 sec when executed from psql
prompt
takes >15 sek when executed from a function (and takes >95% of cpu for
all that time ?
example (on 7.0.2)
>UPDATE item SET id_path = '';
returns immediately (on 2000 item table)
then I create a function
CREATE FUNCTION
