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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026