Postgres Pro
Downloads
Home   >   mailing lists

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

From Adam Brusselback
Subject Re: [PERFORM] Stored Procedure Performance
Date
Msg-id CAMjNa7fwCbh4YuwUY5D7W5bM90aqUEqw-goYAvAt3UFvT0kjqg@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Stored Procedure Performance  (Purav Chovatia <puravc@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
tryingby commenting that part?
 

That is likely it.  Comment that out and test.
If you still need to handle a unique violation, see if you can instead
use the ON CONFLICT clause on the INSERT.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Purav Chovatia
Date:
Subject: Re: [PERFORM] Stored Procedure Performance
Next
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] Stored Procedure Performance