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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
