Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Date
Msg-id 17615.1105658710@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> SELECT delitel(1000000, 1);

> Mean times over the last five of six runs on my poor 500MHz FreeBSD
> 4.11-PRERELEASE box:

> 6741 ms   7.4.6 (from FreeBSD ports collection)
> 14427 ms  8.0.0rc5 (from CVS source)

When I add IMMUTABLE to the function definition, I get much closer
times.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Next
From: Mark Kirkwood
Date:
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)