> Does PostgreSQL create an implicit index also for foreign keys? or must > I create it explicitly?
No, you foreign keys are not automatically indexed. They only way they would
be is if the FK is
part of a composite unique or primary key. So you will probably have to create
your one indexes
on FKs.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
