Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group