Re: Indexing foreign keys

From: Matt Mello <alien(at)spaceship(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Indexing foreign keys
Date: 2003-01-28 05:51:31
Message-ID: 3E361A63.6010409@spaceship.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Carmack 2003-01-28 06:02:31 Re: Using RSYNC for replication?
Previous Message Matt Mello 2003-01-28 05:46:46 Re: Indexing foreign keys

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-01-28 07:49:52 Re: Indexing foreign keys
Previous Message Matt Mello 2003-01-28 05:46:46 Re: Indexing foreign keys