pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIndexes advantageous on foreign key columns
2+ messages / 2 participants
[nested] [flat]
* Indexes advantageous on foreign key columns
@ 2010-05-26 18:33 Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
0 siblings, 1 reply; 2+ messages in thread
From: Maria L. Wilson @ 2010-05-26 18:33 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Indexes advantageous on foreign key columns
@ 2010-05-26 18:38 Szymon Guz <mabewlun@gmail.com>
parent: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Szymon Guz @ 2010-05-26 18:38 UTC (permalink / raw)
To: Maria.L.Wilson-1@nasa.gov; +Cc: pgsql-admin
2010/5/26 Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
> 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
>
>
That depends. They are not necessary. They are overhead (like all other
indexes). They can be useful, or not be useful. Can be used or not.
All depends mainly on your queries and how many records you have. If you
have enough, the index can be really helpful (of course that depends on the
query that you make).
regards
Szymon Guz
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-05-26 18:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-26 18:33 Indexes advantageous on foreign key columns Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
2010-05-26 18:38 ` Szymon Guz <mabewlun@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox