Re: performance of foreign key constraints

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: teknokrat(at)yahoo(dot)com
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance of foreign key constraints
Date: 2003-08-28 18:58:18
Message-ID: 1062097097.79027.214.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The references are all to the same table i.e. they are employee ids, so
> leaving some and not others would make no sense. The table has no
> deletes, small amount of inserts and moderate amount of updates. However
> there are many selects and its their performance I am most concerned with.

Foreign keys have no impact on selects.

Although this does sound like a rather strange design to me (20+ columns
wide and they're all employee ids?)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2003-08-28 19:16:11 Re: The results of my PostgreSQL/filesystem performance
Previous Message Anders K. Pedersen 2003-08-28 18:57:02 Re: Queries sometimes take 1000 times the normal time