Re: [PERFORM] postgresql tuning with perf

> 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.

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