Re: constraints and performance

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: constraints and performance
Date: 2004-02-11 14:06:46
Message-ID: m3smhh7ls9.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

A long time ago, in a galaxy far, far away, jkanter(at)virginia(dot)edu (Jodi Kanter) wrote:
> Do constraints effect performance significantly?

They would be expected to provide a significant enhancement to
performance over:
a) Firing triggers,
b) Firing rules, and
c) Forcing the application to validate the data, and then adding
in "data validation" reports to report on the cases where a buggy
application violated the constraints.

So yes, they should be considerably faster than any of their
alternatives.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','ntlug.org').
http://cbbrowne.com/info/lsf.html
"The only constructive theory connecting neuroscience and psychology
will arise from the study of software."
-- Alan Perlis
[To the endless aggravation of both disciplines. Ed.]

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Mennie 2004-02-11 14:25:53 Re: hanging for 30sec when checkpointing
Previous Message Jodi Kanter 2004-02-11 13:21:01 constraints and performance