Re: Foreign keys and indexes

From: Ragnar <gnari(at)hive(dot)is>
To: Marc Compte <mcompte(at)sigte(dot)udg(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Foreign keys and indexes
Date: 2007-06-05 13:30:15
Message-ID: 1181050216.5953.16.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On þri, 2007-06-05 at 11:49 +0200, Marc Compte wrote:

> Does PostgreSQL create an implicit index also for foreign keys?

no

> or must I create it explicitly?

if you want one, yes.

not everyone wants an index on all their foreign keys,
but they can be useful in some circumstances.

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Mathis 2007-06-05 13:31:02 Re: Encrypted column
Previous Message A. Kretschmer 2007-06-05 13:25:30 Re: Foreign keys and indexes