Re: Indexes for Foreign Keys?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Larsen" <jlar310(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Indexes for Foreign Keys?
Date: 2007-10-29 18:59:03
Message-ID: 14807.1193684343@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Jeff Larsen" <jlar310(at)gmail(dot)com> writes:
> I've noticed that PG automatically creates indexes when you create a
> primary key. But when you create a foreign key on a child table, it
> does not create an index on the referencing columns of the child
> table.

This is intentional since depending on what your workload is like,
the index on the child table might be more overhead than it's worth.

If you frequently do updates or deletes on the parent column, you'll
want to have the child column indexed.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Teodor Sigaev 2007-10-29 19:29:35 Re: Problem with PITR Past Particular WAL File
Previous Message Medi Montaseri 2007-10-29 18:58:50 Re: [HACKERS] grep command