Re: Indexing foreign keys - Mailing list pgsql-performance

From Matt Mello
Subject Re: Indexing foreign keys
Date
Msg-id 3E361A63.6010409@spaceship.com
Whole thread Raw
In response to Re: Indexing foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-performance
> You don't always need to create them, because there are fk patterns where
> an index is counterproductive, but if you're not in one of those cases you
> should create them.  I'm not sure the docs actually say anything about
> this however.

I would try to add a comment about this to the interactive docs if they
weren't so far behind already (7.2.1).   :\

--
Matt Mello


pgsql-performance by date:

Previous
From: Matt Mello
Date:
Subject: Re: Indexing foreign keys
Next
From: Stephan Szabo
Date:
Subject: Re: Indexing foreign keys