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

Re: contrib idea

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: contrib idea
Date: 2001-12-21 16:09:59
Message-ID: 3C235ED7.7000701@pacifier.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:


> We should not *force* people to have an index.  If the master table very
> seldom changes, then an index on the referencing table will be a net
> loss (at least as far as the foreign-key ops go).  You'll pay for it on
> every referencing-table update, and use it only seldom.


Not only that but it's non standard ... people porting code over which 
correctly defines an explicit index when appropriate would end up with 
two of them.


> Possibly there should be an entry in the "performance tips" chapter
> recommending that people consider adding an index on the referencing
> column if they are concerned about the speed of updates to the
> referenced table.  But I dislike software that considers itself smarter
> than the DBA.


This is a much better idea.




-- 
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org


In response to

Responses

pgsql-hackers by date

Next:From: mlwDate: 2001-12-21 19:52:29
Subject: contrib/dbase
Previous:From: Tom LaneDate: 2001-12-21 16:00:01
Subject: Re: 7.2 is slow?

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