Re: SQL Function Slowness, 8.3.0

by mark@[EMAIL PROTECTED] (Mark Mielke) Apr 16, 2008 at 11:14 AM

This is a multi-part message in MIME format.
--------------040406060805030807020007
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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@[EMAIL PROTECTED]
>


--------------040406060805030807020007
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Are you going to post the function? :-)<br>
<br>
My PL/PGSQL functions are running fine in 8.3.x.<br>
<br>
Cheers,<br>
mark<br>
<br>
<br>
Gavin M. Roy wrote:
<blockquote
 cite="mid:af1bce590804160806t58f7da1g50fc697dd9e6ab08@[EMAIL PROTECTED]
"
 type="cite"><span class="Apple-style-span"
 style="border-collapse: collapse;">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. &nbsp;Basically I have a
query which executes in 5ms but when wrapped in a SQL function, takes
500ms. &nbsp;I've checked all the types passed in to make sure they match
so
there is no type conversions taking place in execution.
  <div><br>
  </div>
  <div>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. &nbsp;I've previously not run into such an order of magnitude
difference in using SQL functions. &nbsp;Is this a change of behavior in
8.3
from 8.2? &nbsp;Without specific examples, are there any recommendations
on
how to speed up these functions?</div>
  <div><br>
  </div>
  <div>Thanks,</div>
  <div><br>
  </div>
  <div>Gavin</div>
  <div><br>
  </div>
  </span></blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Mark Mielke <a class="moz-txt-link-rfc2396E"
href="mailto:mark@[EMAIL PROTECTED]
">&lt;mark@[EMAIL PROTECTED]
>
</pre>
</body>
</html>

--------------040406060805030807020007--

17 Posts in Topic:

SQL Function Slowness, 8.3.0

gmr@[EMAIL PROTECTED] (&

2008-04-16 11:06:35

Re: SQL Function Slowness, 8.3.0

tgl@[EMAIL PROTECTED] (T

2008-04-16 11:09:47

Re: SQL Function Slowness, 8.3.0

mark@[EMAIL PROTECTED] (

2008-04-16 11:14:26

Re: SQL Function Slowness, 8.3.0

gmr@[EMAIL PROTECTED] (&