Indexing Foreign Key Columns

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Indexing Foreign Key Columns
Date: 2007-08-28 12:53:13
Message-ID: 20070828075313.6b20b716@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am curious if there are any rules of thumb for when to index a
foreign key column? I was under the impression that it was always a
good idea to do this based on the fact that you typically join
through a foreign key but after reading the docs I'm not so sure it's
necessary or provides any improvements to join query speed.

Thanks,

Josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2007-08-28 12:57:11 Re: [GENERAL] One database vs. hundreds?
Previous Message Markus Schiltknecht 2007-08-28 12:47:40 Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)