The language used for stored procedures is EDBSPL. Even if we dont use EDBSPL, and instead use PLPgPSQL, the performance is still the same.
Thanks
On 24 October 2017 at 03:29, Steve Atkins <steve@blighty.com> wrote:
> 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 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.