Re: Performance problems testing with Spamassassin 3.1.0

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Date: 2005-07-29 17:38:04
Message-ID: 200507291038.04230.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-07-29 17:46:10 Re: Performance problems on 4/8way Opteron (dualcore) HP DL585
Previous Message Matthew Schumacher 2005-07-29 17:37:42 Re: Performance problems testing with Spamassassin 3.1.0