Re: [PERFORM] foreign key performance

2005-04-21 Thread Alvaro Herrera
On Fri, Apr 22, 2005 at 02:06:15AM +0200, Enrico Weigelt wrote: > do foreign keys have any influence on performance (besides slowing > down huge inserts) ? do they bring any performance improvement ? No. They only cause additional tables to be visited to enforce them. -- Alvaro Herrera (<[EMAI

[PERFORM] foreign key performance

2005-04-21 Thread Enrico Weigelt
Hi folks, do foreign keys have any influence on performance (besides slowing down huge inserts) ? do they bring any performance improvement ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931