Josh Berkus wrote:
>> 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:
IF found THEN return;
So really, the exception should never be triggered.
In response to
pgsql-performance by date
|Next:||From: Jeffrey W. Baker||Date: 2005-07-29 18:55:42|
|Subject: Re: Performance problems on 4/8way Opteron (dualcore) HP|
|Previous:||From: Luke Lonergan||Date: 2005-07-29 17:54:08|
|Subject: Re: [PATCHES] COPY FROM performance improvements|