Once again you are speaking about edb port of postgresql. The edb pl sql code
is not public. This is not the good place to get support: please ask your
edb contract manager.
If you want support hère: please rewrite your oracle proc in pl pqsql, share
that code and commit strategy ... Postgres doesn
We record like this: perf record -g -u enterprisedb
We report like this: perf report -g -i perf.data
Is this what you were looking for? Sorry, we are new to perf so we might be
sharing something different as compared to what you asked.
We already shared the SP code in the original post.
Thanks
Please share how you monitor your perfs.
At less duration for each plpgsql proc / oracle proc.
Please share your plpgsql code, and commit strategy.
(for support with edb please check with your contract manager)
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.ht
Hi Pascal,
Do you mean the sample program that acts as the application, do you want me
to share that? I can do that, but I guess my post will get blocked.
Yes, c1 is the PK. Pls see below:
bmdb=# desc dept_new
Table "public.dept_new"
Column | Type | Modifiers
+
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 wrote:
>
> > On Oct 23, 2017, at 12:19 PM, Purav Chovatia wrote:
> >
> > Hello Experts,
> >
> > We are tr
> On Oct 23, 2017, at 12:19 PM, Purav Chovatia 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.
On 10/23/2017 09:19 PM, Purav Chovatia wrote:
> Hello Experts,
>
> We are trying to tune our postgresql DB using perf.
Can you share some of the perf reports, then?
> We are running a C program that connects to postgres DB and calls
> very simple StoredProcs, one each for SELECT, INSERT & UPDA
Hi,
could you providence the code used with PG ?
Has table dept_new an index/pk on c1 ?
Do you analyze this table after loading it ?
Regards
PAscal
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
--
Sent via pgsql-performance mailing list (pgsql-performa
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 OU
