Re: foreign key performance - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: foreign key performance
Date
Msg-id 20050422035521.GE24057@dcc.uchile.cl
Whole thread Raw
In response to foreign key performance  (Enrico Weigelt <weigelt@metux.de>)
List pgsql-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 (<alvherre[@]dcc.uchile.cl>)
"Ciencias políticas es la ciencia de entender por qué
 los políticos actúan como lo hacen"  (netfunny.com)

pgsql-performance by date:

Previous
From: "Shoaib Burq (VPAC)"
Date:
Subject: Re: two queries and dual cpu (perplexed)
Next
From: Gavin Sherry
Date:
Subject: Re: two queries and dual cpu (perplexed)