* Ravi Chemudugunta (chemuduguntar(at)gmail(dot)com) wrote:
> Which version is faster?
In general I would recommend that you benchmark them using
as-close-to-real load as possible again as-real-as-possible data.
> Does the exception mechanism add any overhead?
Yes, using exceptions adds a fair bit of overhead. Quote from the
documentation found here:
Tip: A block containing an EXCEPTION clause is significantly more
expensive to enter and exit than a block without one. Therefore, don't
use EXCEPTION without need.
> Which is more cleaner?
That would be in the eye of the beholder, generally. Given the lack of
complexity, I don't think 'cleanness' in this case really matters all
In response to
pgsql-performance by date
|Next:||From: Stephen Denne||Date: 2008-04-01 00:56:35|
|Subject: Re: Performance Implications of Using Exceptions|
|Previous:||From: Ravi Chemudugunta||Date: 2008-04-01 00:20:34|
|Subject: Performance Implications of Using Exceptions|