Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing foreign keys - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Indexing foreign keys
Date
Msg-id 200301271312.09105.josh@agliodbs.com
Whole thread Raw
In response to Re: Indexing foreign keys  (Matt Mello <alien@spaceship.com>)
Responses Re: Indexing foreign keys
List pgsql-performance
Tree view 
Matt,

> Did the docs say to index those FK fields (is that standard in the DB
> industry?), or was I just spoiled by IFX doing it for me?  ;)

It's pretty standard in the DB industry.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 7.3.1 New install, large queries are slow
Next
From: Ron Johnson
Date:
Subject: Re: Indexing foreign keys