Home > mailing lists

Creating indices on foreign keys - Mailing list pgsql-general

From	Sanjay
Subject	Creating indices on foreign keys
Date	August 29, 2007 23:05:26
Msg-id	1188284898.651887.45810@d55g2000hsg.googlegroups.com Whole thread Raw
Responses	Re: Creating indices on foreign keys (Sanjay <skpatel20@gmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Tom Lane
Date: 29 August 2007, 23:05:25
Subject: Re: psql \copy command runs as a transcation?

From: Trent Shipley
Date: 29 August 2007, 23:05:27
Subject: Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)

Creating indices on foreign keys - Mailing list pgsql-general

Previous

Next