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? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
