Creating indices on foreign keys

Started by Sanjayover 18 years ago2 messagesgeneral
Jump to latest
#1Sanjay
skpatel20@gmail.com

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

#2Sanjay
skpatel20@gmail.com
In reply to: Sanjay (#1)
Re: Creating indices on foreign keys

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?

Refering the discussion here, I assume I am correct:

http://groups.google.co.in/group/pgsql.general/browse_thread/thread/516db5b5f36c82d0

thanks
Sanjay