MIME-Version: 1.0
In-Reply-To: 
 <CADrzpjHWww9dV8Wrb9aioT1J2TY-QdeUFVn61tn5SqtqX6PfoA@mail.gmail.com>
References: 
 <CADrzpjHChC6q0NGMG0wZUFvj-A0QO3WL9JONLcmRRCZuPnQQNQ@mail.gmail.com>
 <1507042486.2998.1.camel@cybertec.at>
 <CADrzpjG3SDW1OxAFrYVNq63M6WA_y=DL27DenZ=tHmr=6L6Y0w@mail.gmail.com>
 <CAFj8pRCnzVUz69PNKwUZWeGP7P0xv0QznB_bwHHhgogLcqeo1w@mail.gmail.com>
 <CADrzpjGMe4KUQrk8VSfmNmF6DYcuUq7mZTsBu4jaNx0YDrB-qw@mail.gmail.com>
 <CAMjNa7eWtpCnf9uDgN4FAXTtNLUw1sbtgaTin4uHJGZpAjDm5Q@mail.gmail.com>
 <CADrzpjHWww9dV8Wrb9aioT1J2TY-QdeUFVn61tn5SqtqX6PfoA@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Wed, 11 Oct 2017 21:06:42 +0200
Message-ID: 
 <CAFj8pRBiBN9T9bCMfyT2oQ7SAP1Aq9wH5=b=yBkA1W6O-HGTvQ@mail.gmail.com>
Subject: Re: Stored Procedure Performance
To: Purav Chovatia <puravc@gmail.com>
Cc: Adam Brusselback <adambrusselback@gmail.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="94eb2c069454377cfb055b4a22b8"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--94eb2c069454377cfb055b4a22b8
Content-Type: text/plain; charset="UTF-8"

2017-10-11 18:52 GMT+02:00 Purav Chovatia <puravc@gmail.com>:

> Yes, there is some code to catch exceptions like unique constraint
> violation and no data found. Do you suggest we trying by commenting that
> part? btw, the dataset is a controlled one, so what I can confirm is we are
> not hitting any exceptions.
>

If it is possible, don't do it in cycle, or use exception handling only
when it is necessary, not from pleasure.

Regards

Pavel


> Thanks
>
> On 11 October 2017 at 22:07, Adam Brusselback <adambrusselback@gmail.com>
> wrote:
>
>> Is there any error handling in there?  I remember seeing performance
>> issues if you put in any code to catch exceptions.
>>
>
>

--94eb2c069454377cfb055b4a22b8
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-11 18:52 GMT+02:00 Purav Chovatia <span dir=3D"ltr">&lt;<a href=
=3D"mailto:puravc@gmail.com" target=3D"_blank">puravc@gmail.com</a>&gt;</sp=
an>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border=
-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Yes, there is some =
code to catch exceptions like unique constraint violation and no data found=
. Do you suggest we trying by commenting that part? btw, the dataset is a c=
ontrolled one, so what I can confirm is we are not hitting any exceptions.<=
/div></blockquote><div><br></div><div>If it is possible, don&#39;t do it in=
 cycle, or use exception handling only when it is necessary, not from pleas=
ure.</div><div><br></div><div>Regards</div><div><br></div><div>Pavel</div><=
div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;=
border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><br></di=
v><div>Thanks</div></div><div class=3D"HOEnZb"><div class=3D"h5"><div class=
=3D"gmail_extra"><br><div class=3D"gmail_quote">On 11 October 2017 at 22:07=
, Adam Brusselback <span dir=3D"ltr">&lt;<a href=3D"mailto:adambrusselback@=
gmail.com" target=3D"_blank">adambrusselback@gmail.com</a>&gt;</span> wrote=
:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-le=
ft:1px #ccc solid;padding-left:1ex">Is there any error handling in there?=
=C2=A0 I remember seeing performance<br>
issues if you put in any code to catch exceptions.<br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div>

--94eb2c069454377cfb055b4a22b8--