Re: constraints and performance

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: constraints and performance
Дата
Msg-id m3smhh7ls9.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на constraints and performance  (Jodi Kanter <jkanter@virginia.edu>)
Ответы Re: constraints and performance  (postgres@jal.org)
Список pgsql-admin
A long time ago, in a galaxy far, far away, jkanter@virginia.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.]

В списке pgsql-admin по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Upgrading from 7.2 to 7.4.1 on Redhat 7
Следующее
От: hehe88hk@yahoo.com.hk (Eric)
Дата:
Сообщение: Showing all groups