Re: contrib idea - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: contrib idea
Date
Msg-id 200112210358.fBL3wew22397@candle.pha.pa.us
Whole thread Raw
In response to contrib idea  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: contrib idea  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> Hi All,
> 
> You know how when you create a foreign key in postgres it isn't
> automatically indexed, and it seems to me that it's very useful to have
> indexed foreign keys, especially if you use lots of them.
> 
> So, how about a 'findslowfks' contrib?  This would basically be similar to
> Bruce's findoidjoins thingy...

Why would you want an index on a foreign key.  Primary I can understand,
but is there use to foreignt?  Is it for checking of changes to primary
keys?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Status on RC1?
Next
From: Tom Lane
Date:
Subject: Re: The dbase conrtib doesn't compile