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