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

From Rod Taylor
Subject Re: performance of foreign key constraints
Date
Msg-id 1062097097.79027.214.camel@jester
Whole thread Raw
In response to Re: performance of foreign key constraints  (teknokrat <teknokrat@yahoo.com>)
Responses Re: performance of foreign key constraints  (teknokrat <teknokrat@yahoo.com>)
List 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?)

Attachment

pgsql-performance by date:

Previous
From: "Anders K. Pedersen"
Date:
Subject: Re: Queries sometimes take 1000 times the normal time
Next
From: Bill Moran
Date:
Subject: Re: The results of my PostgreSQL/filesystem performance