Re: pl/pgsql slowness - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pl/pgsql slowness
Date
Msg-id 27955.974736854@sss.pgh.pa.us
Whole thread Raw
In response to pl/pgsql slowness  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: building current sources
Next
From: Hannu Krosing
Date:
Subject: Re: Table/Column Constraints