public inbox for [email protected]  

help / color / mirror / Atom feed

From: Purav Chovatia <[email protected]>
To: Steve Atkins <[email protected]>
Cc: [email protected]
Subject: Re: postgresql tuning with perf
Date: Tue, 24 Oct 2017 13:06:24 +0530
Message-ID: <CADrzpjHFZLNNPYOebzxgGhFohOEb-4WjNrXAcX+jgmO4p87z2w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CADrzpjHuvgoTNOQosjHDaJ8YW=jDiwCn8u2h8A1HWRTaPzVc5w@mail.gmail.com>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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 <[email protected]> wrote:

>
> > On Oct 23, 2017, at 12:19 PM, Purav Chovatia <[email protected]> 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 ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: postgresql tuning with perf
  In-Reply-To: <CADrzpjHFZLNNPYOebzxgGhFohOEb-4WjNrXAcX+jgmO4p87z2w@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox