Postgres Pro
Downloads
Home   >   mailing lists

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

From Purav Chovatia
Subject Re: [PERFORM] Stored Procedure Performance
Date
Msg-id CADrzpjHWww9dV8Wrb9aioT1J2TY-QdeUFVn61tn5SqtqX6PfoA@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Stored Procedure Performance  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: [PERFORM] Stored Procedure Performance  (Adam Brusselback <adambrusselback@gmail.com>)
Re: [PERFORM] Stored Procedure Performance  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: [PERFORM] Stored Procedure Performance
Next
From: Adam Brusselback
Date:
Subject: Re: [PERFORM] Stored Procedure Performance