Re: performance of foreign key constraints - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: performance of foreign key constraints
Date
Msg-id 20030828172539.GA17195@libertyrms.info
Whole thread Raw
In response to performance of foreign key constraints  (teknokrat <teknokrat@yahoo.com>)
List pgsql-performance
On Thu, Aug 28, 2003 at 06:15:57PM +0100, teknokrat wrote:
> I have a table that has about 20 foreign key constraints on it. I think
> this is a bit excessive and am considering removing them ( they are all
> related to the same table and I don't think there is much chance of any
> integrity violations ). Would this improve performance or not?

Almost certainly.  But there's probably room for some middle ground
between 20 and none.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: teknokrat
Date:
Subject: performance of foreign key constraints
Next
From: Stephan Szabo
Date:
Subject: Re: performance of foreign key constraints