MIME-Version: 1.0
In-Reply-To: 
 <CAMjNa7dQYE44gisjODEWECs82oAjj5Q7pDDhFKmP_aYX3dZYow@mail.gmail.com>
References: 
 <CADrzpjHChC6q0NGMG0wZUFvj-A0QO3WL9JONLcmRRCZuPnQQNQ@mail.gmail.com>
 <1507042486.2998.1.camel@cybertec.at>
 <CAMjNa7dQYE44gisjODEWECs82oAjj5Q7pDDhFKmP_aYX3dZYow@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Tue, 3 Oct 2017 17:28:55 +0200
Message-ID: 
 <CAFj8pRB32vGfzOuQy8ZC03Jvgx8hKL4_P7Zv4oO_w0dmUKbP-w@mail.gmail.com>
Subject: Re: Stored Procedure Performance
To: Adam Brusselback <adambrusselback@gmail.com>
Cc: Purav Chovatia <puravc@gmail.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="001a11441764a1f6ae055aa62855"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a11441764a1f6ae055aa62855
Content-Type: text/plain; charset="UTF-8"

2017-10-03 17:17 GMT+02:00 Adam Brusselback <adambrusselback@gmail.com>:

> There is also the option of pg_stat_statements: https://
> www.postgresql.org/docs/current/static/pgstatstatements.html and
> auto_explain: https://www.postgresql.org/docs/current/
> static/auto-explain.html
>
> These should help you identify what is slowing things down.  There is no
> reason I could think of you should be seeing a 10x slowdown between
> Postgres and Oracle, so you'll likely have to just profile it to find out.
>

depends what is inside.

The max 10x slow down is possible if you are hit some unoptimized cases.
The times about 1ms - 10ms shows so procedure (code) can be very sensitive
to some impacts.

Regards

Pavel

--001a11441764a1f6ae055aa62855
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quo=
te">2017-10-03 17:17 GMT+02:00 Adam Brusselback <span dir=3D"ltr">&lt;<a hr=
ef=3D"mailto:adambrusselback@gmail.com" target=3D"_blank">adambrusselback@g=
mail.com</a>&gt;</span>:<br><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"=
><div class=3D"gmail_extra">There is also the option of pg_stat_statements:=
=C2=A0<a href=3D"https://www.postgresql.org/docs/current/static/pgstatstate=
ments.html" target=3D"_blank">https://<wbr>www.postgresql.org/docs/<wbr>cur=
rent/static/<wbr>pgstatstatements.html</a> and auto_explain:=C2=A0<a href=
=3D"https://www.postgresql.org/docs/current/static/auto-explain.html" targe=
t=3D"_blank">https://www.<wbr>postgresql.org/docs/current/<wbr>static/auto-=
explain.html</a></div><div class=3D"gmail_extra"><br></div><div class=3D"gm=
ail_extra">These should help you identify what is slowing things down.=C2=
=A0 There is no reason I could think of you should be seeing a 10x slowdown=
 between Postgres and Oracle, so you&#39;ll likely have to just profile it =
to find out.</div></div></blockquote><div><br></div><div>depends what is in=
side.</div><div><br></div><div>The max 10x slow down is possible if you are=
 hit some unoptimized cases. The times about 1ms - 10ms shows so procedure =
(code) can be very sensitive to some impacts. <br></div><div><br></div><div=
>Regards</div><div><br></div><div>Pavel<br></div></div><br></div></div>

--001a11441764a1f6ae055aa62855--