> On Oct 23, 2017, at 12:19 PM, Purav Chovatia <puravc@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
verysimple 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
likethis then I don't think you're using PostgreSQL.
Cheers, Steve
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance