Re: Functions too slow, even with iscachable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Ang Chin Han <angch(at)pintoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Functions too slow, even with iscachable?
Date: 2000-08-07 15:52:18
Message-ID: 6291.965663538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> At 10:58 7/08/00 -0400, Tom Lane wrote:
>> Looks like we need to teach the optimizer that expressions involving
>> params can be treated like simple params for the purposes of
>> optimization.

> So long as the function is cacheable...

Yes, of course --- but the same problem currently arises for cases like
"var = param + 1" ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-08-07 19:39:12 foreign key take too much time to check
Previous Message Rob van der Leek 2000-08-07 15:17:09 Changing user passwords