On Tue, Jun 05, 2007 at 11:49:20AM +0200, Marc Compte wrote: > Does PostgreSQL create an implicit index also for foreign keys? or must > I create it explicitly?
PostgreSQL doesn't create an index on the referencing column(s) of a foreign key constraint; if you want an index then you'll need to create it yourself. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match