Re: [WIP] Caching constant stable expressions per execution

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Date: 2011-09-11T01:46:57Z
Lists: pgsql-hackers
> If I understand the limitations correctly, though, what this would do is
> cause functions to perform substantially differently if called with
> expressions as arguments instead of text constants, no?  Seems like that
> would lead to some user confusion.  Although, with stuff like now(), we
> already have that.

After some discussion on IRC, I realized I misunderstood the limitations
of the patch.  I'd say that this would be a significant improvement for
a large number of real-world cases.  The more in-depth solution ... that
is, one which would accept column parameters ... would of course make
this patch obsolete, but AFAIK nobody is working on that yet.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com