Performance of pl/pgsql functions?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Performance of pl/pgsql functions?
Дата
Msg-id CAOC+FBUjq=uk2+9eqXnJPu8mYTUoX119T+DHw_wNLJdXysEfiA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Performance of pl/pgsql functions?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Performance of pl/pgsql functions?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Do these tend to perform well? I have some simple formulas in functions like so:

CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
  RETURNS numeric AS
$BODY$

declare ret numeric;

begin
select (a+b) / c::numeric into ret;
return round(ret, 3);
end

$BODY$
LANGUAGE plpgsql IMMUTABLE COST 100;

The reason I'm doing this is because i repeat this formula in a bunch of views and queries, and it's easier to have one function. Would this somehow be slower than reproducing the formula in every view its used? I'm hoping not...

--
Wells Oliver
wellsoliver@gmail.com

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

Предыдущее
От: François Beausoleil
Дата:
Сообщение: Re: pg_dump -Fd must create directory
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Performance of pl/pgsql functions?