Re: [PERFORM] foreign key performance
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 (<[EMAIL PROTECTED]>) "Ciencias políticas es la ciencia de entender por qué los políticos actúan como lo hacen" (netfunny.com) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[PERFORM] foreign key performance
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 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 174 7066481 - -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops -- - ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq