Horton

Re: Performance problems testing with Spamassassin 3.1.0

John Arbash Meinel <john@arbash-meinel.com>

View thread
From: John Arbash Meinel <john@arbash-meinel.com>
To: josh@agliodbs.com
Cc: Dennis Bjorklund <db@zigo.dhs.org>, Matthew Schumacher <matt.s@aptalaska.net>, pgsql-performance@postgresql.org
Date: 2005-07-29T18:29:46Z
Lists: pgsql-performance 
Josh Berkus wrote:

>Dennis,
>
>  
>
>>      EXCEPTION WHEN unique_violation THEN
>>    
>>
>
>I seem to remember that catching an exception in a PL/pgSQL procedure was a 
>large performance cost.   It'd be better to do UPDATE ... IF NOT FOUND.
>
>  
>
Actually, he was doing an implicit UPDATE IF NOT FOUND in that he was doing:

UPDATE

IF found THEN return;

INSERT
EXCEPT
...

So really, the exception should never be triggered.
John
=:->