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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Kane Tao <khtao(at)yahoo(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org, "Vadim B(dot) Mikheev" <vadim(at)krs(dot)ru>
Subject: Re: Fw: Re[2]: [GENERAL] Joins and links
Date: 1999-07-05 21:21:34
Message-ID: 199907052121.RAA07363@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bitmead 1999-07-05 23:56:41 Re: Fw: Re[2]: [GENERAL] Joins and links
Previous Message Albert Chen 1999-07-05 19:40:15 Date convertion problem.