Postgres Pro
Downloads
Home   >   mailing lists

performance of foreign key constraints - Mailing list pgsql-performance

From teknokrat
Subject performance of foreign key constraints
Date
Msg-id bildcd$232q$1@news.hub.org
Whole thread Raw
Responses Re: performance of foreign key constraints  (Andrew Sullivan <andrew@libertyrms.info>)
Re: performance of foreign key constraints  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-performance
Tree view 
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?

thanks

pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: Andrew Sullivan
Date:
Subject: Re: performance of foreign key constraints