Re: SQL Function Performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-------Original Message-------
 
Date: 02/14/06 01:46:16
Subject: RE: [PERFORM] SQL Function Performance
 

>> in my case; both direct query and sql function gererate same execution plan. Also, execution plan belongs to the sql function better than direct sql
>> query plan. But, direct sql result comes less than 1 second. sql function result comes about in 50 seconds.

>How are you getting at the plan inside your function?  If you just do an EXPLAIN on the function call you get a FUNCTION SCAN line in your plan, which tells you >nothing.  I remember I had to work through some process for catching the output of the Explain plan in a cursor and returning that to actually see the plan.  I saw in a >previous response he suggested using a PREPARE and EXECUTE against that.  I'm not sure that's the same as what's going on in the function (although I could be >wrong).

   Yes, i have got sql function prepared execution plan using PREPARE and EXECUTE that he suggested to me.


>Just humor me and try creating the sql query in the fuction in a text variable and then Executing it. 

   But i believe that, that behavior of PostgreSQL is not good. It should handle this case. PostgreSQL has this "sql function" functionality and it should
   give good serve...Of course, i will do your suggesion if i dont solve it.

>Prior to that, however, you might try just recreating the function.  The plan may be re-evaluated at that point.
    Ok. i did it many times. But nothing was changed..
- Mark

 
Adnan DURSUN
ASRIN Bilişim Ltd.Şti


 

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux