On Wed, May 13, 2009 at 10:37 AM, John Lister <john(dot)lister(at)kickstone(dot)com>wrote:
> Probably easier to create a server side function instead, then.
>>>>
>>> But wouldn't you still have to go through all the planning steps within
>>> the function for any queries, although i'll admit i'm not familiar with
>>> Postgresql functions.
>>>
>>
>> Server-side functions are compiled when installed. Since my function would
>> only contain simple queries that are parameterized, it would pre-compile
>> well.
>>
>
While the function may be compiled, the overhead is the same for preparing
the statement inside the function. So I don't think it's a huge win.