On Wed, 11 Feb 2004, Jodi Kanter wrote:
> Do constraints effect performance significantly?
That depends.
Foreign key constraints on int4 columns or int8 columns (matching of
course) are usually quite fast.
FK constraints on non-int (numeric, text, etc...) tend to be slower.
check constraints can be a killer if they are complex or use functions,
but simple check constraints are usually alright.
Do you have a specific use case you're looking at?