Horton

Re: Performance problems testing with Spamassassin 3.1.0

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: Matthew Schumacher <matt.s@aptalaska.net>, pgsql-performance@postgresql.org
Date: 2005-07-29T17:38:04Z
Lists: pgsql-performance 
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.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco