Performance difference between sql and pgsql function...

Поиск
Список
Период
Сортировка
От Cristian Prieto
Тема Performance difference between sql and pgsql function...
Дата
Msg-id 007401c5dfc2$9d2c41e0$6500a8c0@gt.ClickDiario.local
обсуждение исходный текст
Список pgsql-performance
There any performance differences between a SQL function written in SQL
language or PL/psSQL language? For example:

Create or replace function sp_getfreq(
    Var1 integer
) returns Boolean as
$$
Declare
    Myval Boolean;
Begin
    Select var1 in (select var3 from table1) into myval;
    Return myval;
End;
$$
Language ‘plpgsql’ stable; 

And with:

Create or replace function sp_getfreq(
    Var1 integer
) returns boolean as
$$
Select $1 in (select var3 from table1);
$$
Language ‘sql’ stable;


I know the function is really simple, but in theory which of the three would
run faster?



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: insert performance for win32
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: improvise callbacks in plpgsql