Indexes advantageous on foreign key columns

From: "Maria L(dot) Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Indexes advantageous on foreign key columns
Date: 2010-05-26 18:33:01
Message-ID: 4BFD695D.4030005@nasa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Was hoping that someone would like to discuss the need for indexes on
columns that are referenced in a foreign key. Are they necessary? Are
they worth the overhead? PostgreSQL version 8.4

thanks, Maria Wilson
Nasa, Langley Research Center
Hampton, Virginia 23681

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Szymon Guz 2010-05-26 18:38:45 Re: Indexes advantageous on foreign key columns
Previous Message Kevin Grittner 2010-05-26 16:13:59 Re: Transaction with in function