Re: Fw: Re[2]: [GENERAL] Joins and links

What is MVCC?

Bruce Momjian wrote:
>
> >
> > 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