run check constraints only when affected columns are changed? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject run check constraints only when affected columns are changed?
Date
Msg-id 1326055327.15293.13.camel@vanquo.pezone.net
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Ryan Kelly
Date:
Subject: [PATCH] Allow breaking out of hung connection attempts
Next
From: Magnus Hagander
Date:
Subject: Re: pg_basebackup option for handling symlinks