Re: Re[2]: [HACKERS] Fwd: Joins and links

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re[2]: [HACKERS] Fwd: Joins and links
Дата
Msg-id 199907061504.LAA10481@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re[2]: [HACKERS] Fwd: Joins and links  (Leon <leon@udmnet.ru>)
Список pgsql-hackers
> When you will decide - to implement or not to implement,
> I urge you to think again about the relief on optimizer,
> which I stressed many times. No one rebutted yet that adding
> brains to optimizer so that it can use appropriate join method
> will require major rewrite. With links you get the best join
> method as side effect - virtually for free. These joins
> will never be too slow for an unknown reason. Think carefully.
> I hope you will make wise decision.

I believe Ingres does allow this, as it has tid's too.  If you are
creating a temp table, you could use tids during your processing.  In
fact, it seems tids would be valid until a vacuum is performed.

--  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,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Leon
Дата:
Сообщение: Re[2]: [HACKERS] Fwd: Joins and links
Следующее
От: Clark Evans
Дата:
Сообщение: Re: [HACKERS] Fwd: Joins and links