Creating indices on foreign keys

From: Sanjay <skpatel20(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Creating indices on foreign keys
Date: 2007-08-28 07:08:18
Message-ID: 1188284898.651887.45810@d55g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I think PostgreSQL does not create indexes on foreign keys of a table,
and I have to do so explicitly. That means, wherever I am using master-
detail table, I have to create explicit indexes on the foreign key in
the detail table. Am I wrong?

thanks
Sanjay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kamil Srot 2007-08-28 07:15:26 Re: Tables dissapearing
Previous Message Kamil Srot 2007-08-28 07:06:58 Re: Tables dissapearing