| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: performance of foreign key constraints |
| Date: | 2003-08-28 17:25:39 |
| Message-ID: | 20030828172539.GA17195@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-28 17:28:19 | Re: performance of foreign key constraints |
| Previous Message | teknokrat | 2003-08-28 17:15:57 | performance of foreign key constraints |