Re: [ADMIN] constraints and performance

2004-05-30 Thread postgres
On Wed, 11 Feb 2004, Christopher Browne wrote: > A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote: > > Do constraints effect performance significantly? > > They would be expected to provide a significant enhancement to > performance over: > a) Firing triggers, >

Re: [ADMIN] constraints and performance

2004-02-12 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (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

Re: [ADMIN] constraints and performance

2004-02-11 Thread scott.marlowe
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

[ADMIN] constraints and performance

2004-02-11 Thread Jodi Kanter
Do constraints effect performance significantly? Thanks Jodi -- ___ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED]