Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problems testing with Spamassassin 3.1.0 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Performance problems testing with Spamassassin 3.1.0
Date
Msg-id 200507291038.04230.josh@agliodbs.com
Whole thread Raw
In response to Re: Performance problems testing with Spamassassin 3.1.0  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: Performance problems testing with Spamassassin 3.1.0
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Performance problems testing with Spamassassin
Next
From: Matthew Schumacher
Date:
Subject: Re: Performance problems testing with Spamassassin 3.1.0