Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Date: 2005-01-13 23:25:10
Message-ID: 17615.1105658710@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-01-13 23:55:11 Re: Bug? 8.0 does not use partial index
Previous Message Pavel Stehule 2005-01-13 23:14:43 Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)