Re: Key Vs Index - Mailing list pgsql-general

From Craig Ringer
Subject Re: Key Vs Index
Date
Msg-id 49928198.7030809@postnewspapers.com.au
Whole thread Raw
In response to Re: Key Vs Index  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe wrote:

> Note that the index on the FK side isn't auto created.

Of course, you often don't want one - you might rarely or never DELETE
from the referenced table or UPDATE the primary key value. In that case,
the index just slows down updates and deletes on the table with the fk
without gaining you anything.

--
Craig Ringer

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: Re: Key Vs Index
Next
From: Scott Marlowe
Date:
Subject: Re: Key Vs Index