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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Fw: Re[2]: [GENERAL] Joins and links
Дата
Msg-id 199907052121.RAA07363@candle.pha.pa.us
обсуждение исходный текст
Ответ на Fw: Re[2]: [GENERAL] Joins and links  ("Kane Tao" <death@solaris1.mysolution.com>)
Список 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 по дате отправления:

Предыдущее
От: "Michal Maru¹ka"
Дата:
Сообщение: Re: [GENERAL] Yet Another newbie not understanding why an index isn't used
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: Fw: Re[2]: [GENERAL] Joins and links