> On Oct 23, 2017, at 12:19 PM, Purav Chovatia <puravc@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
