Skip site navigation (1) Skip section navigation (2)

Re: Indexing foreign keys

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>,Matt Mello <alien(at)spaceship(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Indexing foreign keys
Date: 2003-01-27 21:23:19
Message-ID: 200301271323.19644.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Guys,

> 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.

See:
http://techdocs.postgresql.org/techdocs/pgsqladventuresep2.php
http://techdocs.postgresql.org/techdocs/pgsqladventuresep3.php

(and yes, I know I need to finish this series ...)


-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-performance by date

Next:From: Ron St.PierreDate: 2003-01-28 00:06:51
Subject: Re: Indexing foreign keys
Previous:From: Stephan SzaboDate: 2003-01-27 21:16:49
Subject: Re: Indexing foreign keys

pgsql-general by date

Next:From: Tom LaneDate: 2003-01-27 21:37:53
Subject: Re: Date problem
Previous:From: Stephan SzaboDate: 2003-01-27 21:16:49
Subject: Re: Indexing foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group