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 по дате отправления: