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 (<[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

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 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