> On Oct 23, 2017, at 12:19 PM, Purav Chovatia <pur...@gmail.com> wrote:
> Hello Experts,
> We are trying to tune our postgresql DB using perf. We are running a C 
> program that connects to postgres DB and calls very simple StoredProcs, one 
> each for SELECT, INSERT & UPDATE. 
> The SPs are very simple. 
> CREATE OR REPLACE PROCEDURE query_dept_new(p1 IN numeric, p2 OUT numeric,p3 
> OUT numeric,.......,p205 OUT numeric) AS
>     SELECT c2,c3,......,c205
>         INTO p2,p3,.......,p205
>         FROM dept_new
>         WHERE c1 = p1;
> END;

Perhaps I'm confused, but I didn't think PostgreSQL had stored procedures. If 
the code you're actually running looks like this then I don't think you're 
using PostgreSQL.


Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:

Reply via email to