performance of foreign key constraints

From: teknokrat <teknokrat(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: performance of foreign key constraints
Date: 2003-08-28 17:15:57
Message-ID: bildcd$232q$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-28 17:25:39 Re: performance of foreign key constraints
Previous Message Matt Clark 2003-08-28 16:37:24 Re: Hardware recommendations to scale to silly load