any benefit to preparing a sql function?

Поиск
Список
Период
Сортировка
От culley harrelson
Тема any benefit to preparing a sql function?
Дата
Msg-id 1090533485.23982.200903694@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: any benefit to preparing a sql function?
Список pgsql-general
Is there any benefit to preparing a call to a pre-defined sql function
or is the sql function already optimized?

create temp table foo(col1 integer);
insert into foo(col1) values(1);
insert into foo(col1) values(2);
insert into foo(col1) values(3);
insert into foo(col1) values(4);
create or replace function testfunc(integer) returns foo as 'select *
from foo where col1 = $1;' language sql;
prepare myplan(integer) as select * from testfunc($1);
execute myplan(2);

They look exactly the same:

testdb=# explain execute myplan(2);
                           QUERY PLAN
-----------------------------------------------------------------
 Function Scan on testfunc  (cost=0.00..12.50 rows=1000 width=4)
(1 row)
testdb=# explain select * from testfunc(2);
                           QUERY PLAN
-----------------------------------------------------------------
 Function Scan on testfunc  (cost=0.00..12.50 rows=1000 width=4)

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

Предыдущее
От: Si Chen
Дата:
Сообщение: Re: [ADMIN] how to find transaction associated with a lock
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] how to find transaction associated with a lock