Re: [HACKERS] Access to Row ID information in Functions

2008-04-01 Thread Paul Ramsey
Thanks Tom, Yes, we've discussed adding some kind of optional identity information to the object, it remains a potential course of action. Paul On Tue, Apr 1, 2008 at 2:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Paul Ramsey" <[EMAIL PROTECTED]> writes: > > The "optimized" form gets cached an

Re: [HACKERS] Access to Row ID information in Functions

2008-04-01 Thread Tom Lane
"Paul Ramsey" <[EMAIL PROTECTED]> writes: > The "optimized" form gets cached and retrieved from a memory context. > Each time the function is run within a statement it checks the cache, > and sees if one of its arguments are the same as the last time around. > If so, it uses the prepared version of

[HACKERS] Access to Row ID information in Functions

2008-04-01 Thread Paul Ramsey
In PostGIS, we have a problem, in that spatial operations are very costly, CPUwise. We have hit on a nifty enhancement recently, which was to recognize that when processing multiple rows, in joins or with literal argouments, for most functions of the form GeometryOperation(A, B), A (or B) tended t