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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

Next:From: Stephan SzaboDate: 2003-01-28 07:49:52
Subject: Re: Indexing foreign keys
Previous:From: Matt MelloDate: 2003-01-28 05:46:46
Subject: Re: Indexing foreign keys

pgsql-general by date

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

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