From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | psql-novice(at)netzach(dot)co(dot)il |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: STABLE has no effect on PL/pgsql functions |
Date: | 2007-06-01 09:42:08 |
Message-ID: | 1180690928.15764.229.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, 2007-06-01 at 11:54 +0300, psql-novice(at)netzach(dot)co(dot)il wrote:
> I noted in my PG 7.4 on Debian Sarge the following behavior:
Pg 7.4 is 3 versions out of date. Even Debian Sarge is no longer Debian
stable; I think you need to get up to date.
> EXPLAIN ANALYZE SELECT *,reallyHeavyFunctionDefinedAsImmutable() FROM
> my_table;
> time taken: forever
>
> EXPLAIN ANALYZE SELECT *,
> (SELECT reallyHeavyFunctionDefinedAsImmutable())
> FROM my_table;
> time taken: not very long
You have to post the full output of both for anyone to have a chance of
explaining the difference.
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
From | Date | Subject | |
---|---|---|---|
Next Message | psql-novice | 2007-06-01 09:49:47 | Re: STABLE has no effect on PL/pgsql functions |
Previous Message | psql-novice | 2007-06-01 08:54:13 | STABLE has no effect on PL/pgsql functions |