> On Oct 23, 2017, at 12:19 PM, Purav Chovatia <puravc(at)gmail(dot)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.
> SELECT_SP:
> CREATE OR REPLACE PROCEDURE query_dept_new(p1 IN numeric, p2 OUT numeric,p3 OUT numeric,.......,p205 OUT numeric) AS
> BEGIN
> 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.
Cheers,
Steve