Re: SQL Function Slowness, 8.3.0

Are you going to post the function? :-)

My PL/PGSQL functions are running fine in 8.3.x.

Cheers,
mark

Gavin M. Roy wrote:
> In 8.3.0, I'm seeing some oddities with SQL functions which I thought
> were immune to the planner data restrictions of plpgsql functions and
> the sort. Basically I have a query which executes in 5ms but when
> wrapped in a SQL function, takes 500ms. I've checked all the types
> passed in to make sure they match so there is no type conversions
> taking place in execution.
>
> I'm curious about the validity of my expectation that functions
> created with SQL as the language should be as fast as the straight SQL
> counterpart. I've previously not run into such an order of magnitude
> difference in using SQL functions. Is this a change of behavior in
> 8.3 from 8.2? Without specific examples, are there any
> recommendations on how to speed up these functions?
>
> Thanks,
>
> Gavin
>

--
Mark Mielke <mark(at)mielke(dot)cc>