Indexing Foreign Key Columns - Mailing list pgsql-general

From Josh Trutwin
Subject Indexing Foreign Key Columns
Date
Msg-id 20070828075313.6b20b716@sinkhole.intrcomm.net
Whole thread Raw
Responses Re: Indexing Foreign Key Columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: One database vs. hundreds?
Next
From: Alvaro Herrera
Date:
Subject: Re: INSERT doc discrepancy