run check constraints only when affected columns are changed?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема run check constraints only when affected columns are changed?
Дата
Msg-id 1326055327.15293.13.camel@vanquo.pezone.net
обсуждение исходный текст
Ответы Re: run check constraints only when affected columns are changed?  (Andrew Dunstan <andrew@dunslane.net>)
Re: run check constraints only when affected columns are changed?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Currently, check constraints are verified whenever a table row is
updated at all.  It seems to me that we could possibly make this quite a
bit more efficient if we only ran the check constraint expression when
the update changes a column that is referenced by the constraint
expression.  Through dependency tracking, we have that information, and
we already have the catalog infrastructure to store this information
from primary and foreign keys.  We'd just need to do some tweaking in
the executor.  Any thoughts on that?  Possible pitfalls?




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

Предыдущее
От: Ryan Kelly
Дата:
Сообщение: [PATCH] Allow breaking out of hung connection attempts
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_basebackup option for handling symlinks