Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55520=pgsql-performance-ar@postgresql.org>)
	id 1e2KGv-0007bQ-5C
	for pgsql-performance@arkaria.postgresql.org; Wed, 11 Oct 2017 16:54:17 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55520=pgsql-performance-ar@postgresql.org>)
	id 1e2KGu-0001F0-Jq
	for pgsql-performance@arkaria.postgresql.org; Wed, 11 Oct 2017 16:54:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <puravc@gmail.com>)
	id 1e2KFA-0006Tx-3z
	for pgsql-performance@postgresql.org; Wed, 11 Oct 2017 16:52:28 +0000
Received: from mail-wm0-x233.google.com ([2a00:1450:400c:c09::233])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <puravc@gmail.com>)
	id 1e2KF7-0002YA-GN
	for pgsql-performance@postgresql.org; Wed, 11 Oct 2017 16:52:27 +0000
Received: by mail-wm0-x233.google.com with SMTP id i124so6412992wmf.3
        for <pgsql-performance@postgresql.org>;
 Wed, 11 Oct 2017 09:52:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :cc;
        bh=wnx2J7MautYEYgklzZmZzT/1NmL/swQnRwjfI9N3efc=;
        b=ExQJyjJjxv/23ab6D0icD4jEnDMeG3I9wmWaQVgYpCOnIpELN6npHvnUP3WZD5YoMJ
         c4TK7R0nZZe3TFApm5omgorAFqdDmgDTQ4TDPvgVAQzbrGcQUuhBJH7oVCfKaZ/qtsRz
         Ojrjsm3U+AVE8Wdt8w2ygK2TZOr7MvqQn83bSpBK2I3YuBN23ZbcRflgTxWIIMkwH6F6
         CdJR0ynBEwfYkdz3V7pFpaS0PexTFYIsaOc6DI5IXYkcMTrKihTrwI3KjtCrhvYqM1QV
         Eftb5BpL1vj3KyOXmnr0/wWrzkMJ5H3pZzLT70UeLPpnPWENtQ9xjiiVlnquDIqhDVNV
         RzCw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to:cc;
        bh=wnx2J7MautYEYgklzZmZzT/1NmL/swQnRwjfI9N3efc=;
        b=BXUME6JjWEbfC9ZDdHpMz4Rfcvc31P7CiF+AE61Fljkg35kjhZVgkbnOJLG54ETmy3
         27EGXHTuRMQ8/aPcIxsAAEJNij79xAn1Qq1OR0799OdPSDcI2yGR1Vbh+Q1AHDHEYsZc
         mdXTYzOjU1+WzMB4SZ/z5QTEEjM00oWmNriLz77tY7L7FO0UessVwy+rt3l91Xk3BBI2
         1IDXhZj+1QXs0svRNP/4uSYbQIkPJmrtJgLfLXYspDhf/tiTfy/fkc9+CKp2FmXDATjD
         G1nYsAa/3kX8yHueLCYxt0hwXFrtzkMwKdDqUJyx/cOEw+F9S/ia5BbaY+/H0DAzHy4Q
         AQUA==
X-Gm-Message-State: AMCzsaWzQOKqJnmBl0pV0t2zt5d+gKnaUUBp8NcY50jwf/ENF0rHaftI
	9xcRPUJZPtS3aFtlP+llENp5E072r3Hg3uQKE+0=
X-Google-Smtp-Source: 
 AOwi7QDOBIQZ2ktO0hzhvRWjdWaXrDeo8t2Sth67Fc/zt5S80iqPPHn3+I2JPgbRD+488rDQWvnfMTI+r73XaClpj/E=
X-Received: by 10.223.132.163 with SMTP id 32mr202956wrg.218.1507740744421;
 Wed, 11 Oct 2017 09:52:24 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.223.197.78 with HTTP; Wed, 11 Oct 2017 09:52:23 -0700 (PDT)
In-Reply-To: 
 <CAMjNa7eWtpCnf9uDgN4FAXTtNLUw1sbtgaTin4uHJGZpAjDm5Q@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>
From: Purav Chovatia <puravc@gmail.com>
Date: Wed, 11 Oct 2017 22:22:23 +0530
Message-ID: 
 <CADrzpjHWww9dV8Wrb9aioT1J2TY-QdeUFVn61tn5SqtqX6PfoA@mail.gmail.com>
Subject: Re: Stored Procedure Performance
To: Adam Brusselback <adambrusselback@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="94eb2c0d0dde7c1435055b483f8f"
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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

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.

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

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

<div dir=3D"ltr">Yes, there is some code to catch exceptions like unique co=
nstraint violation and no data found. Do you suggest we trying by commentin=
g that part? btw, the dataset is a controlled one, so what I can confirm is=
 we are not hitting any exceptions.<div><br></div><div>Thanks</div></div><d=
iv 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:adambrus=
selback@gmail.com" target=3D"_blank">adambrusselback@gmail.com</a>&gt;</spa=
n> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;b=
order-left: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>

--94eb2c0d0dde7c1435055b483f8f--