Re: Fw: Re[2]: [GENERAL] Joins and links - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Fw: Re[2]: [GENERAL] Joins and links
Date
Msg-id 199907052121.RAA07363@candle.pha.pa.us
Whole thread Raw
In response to Fw: Re[2]: [GENERAL] Joins and links  ("Kane Tao" <death@solaris1.mysolution.com>)
List pgsql-general
>
> Hmm a very interesing theoretical topic...
> Wouldnt make sense to tie this in with the implementation of a Foriegn Key?
> So when the foriegn key is defined you create anoter index that stores all
> the relevant child to parent relationships and can be used to speed up that
> access since it obviously will be a primary access route (else thay wouldnt
> have defined it).  I would think it could be used then to check the Foreign
> Key integrity and used to help maintain/construct clustered tables...
>
>
> And Bruce you sound bitter about MVCC :)

No, I am very excited about MVCC, I just don't expect any statues.
MVCC is much more important to the user community than any 'network'
database changes we could make.

And we don't even know what Vadim looks like.  :-)

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

pgsql-general by date:

Previous
From: "Michal Maru¹ka"
Date:
Subject: Re: [GENERAL] Yet Another newbie not understanding why an index isn't used
Next
From: Chris Bitmead
Date:
Subject: Re: Fw: Re[2]: [GENERAL] Joins and links