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

From Chris Bitmead
Subject Re: Fw: Re[2]: [GENERAL] Joins and links
Date
Msg-id 37814639.112CCC38@tech.com.au
Whole thread Raw
In response to Re: Fw: Re[2]: [GENERAL] Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: Fw: Re[2]: [GENERAL] Joins and links
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fw: Re[2]: [GENERAL] Joins and links
Next
From: Chris Bitmead
Date:
Subject: Re: [GENERAL] Joins and links