> 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.