Re: [PERFORM] Stored Procedure Performance - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: [PERFORM] Stored Procedure Performance
Date
Msg-id CAFj8pRBiBN9T9bCMfyT2oQ7SAP1Aq9wH5=b=yBkA1W6O-HGTvQ@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Stored Procedure Performance  (Purav Chovatia <puravc@gmail.com>)
List pgsql-performance


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.


pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: [PERFORM] Stored Procedure Performance
Next
From: Tomas Vondra
Date:
Subject: Re: [PERFORM] blocking index creation