I need to fine tuning my postgresql for performance, I depend a lot in a couple and few SPs to made a sort of kind of tasks, the most of those pgsql sps are made in pl/pgsql, most of them are simple:
create or replace function sp_one(id integer)
returns setof table1 as
$$
declare
var table1%rowtype;
begin
for var in (select * from table1 where myid=id) loop
return next var;
end loop;
return;
end;
$$
language 'plpgsql' stable;
I think this simple sp would be so much easy as
create or replace function sp_one(id integer)
returns setof table1 as
$$
select * from table1 where myid=$1;
$$
language 'sql' stable;
I guess it sounds more simple but I don't know if it add performance issues in a language or in a simple "inline" sql declarartion...
There are a few more sps a little more complex, mainly in pl/pgsql but I don't know that if I write them in C language it would add more speed to the execution of the code (most of them made a couple of queries)...
Any help?
Thanks a lot!