Re: Foreign keys and indexes

"Marc Compte" <mcompte(at)sigte(dot)udg(dot)es> writes:

> Does PostgreSQL create an implicit index also for foreign keys? or must I
> create it explicitly?

It won't allow you to create a foreign key that points to a column without a
unique index on it.

postgres=# create table b (i integer references a(i));
ERROR: there is no unique constraint matching given keys for referenced table "a"

However if you ever update or delete the referenced records then it also helps
performance to have an index on the referencing column which Postgres doesn't
enforce.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com