Re: Migration to version 7.4
От
Bruce Momjian
Тема
Re: Migration to version 7.4
Дата
Msg-id
200312011553.hB1FrkL18549@candle.pha.pa.us
Ответ на
Re: Migration to version 7.4 (Nabil Sayegh)
Список
Дерево обсуждения
Migration to version 7.4 Nabil Sayegh <postgresql@e-trolley.de>
Re: Migration to version 7.4 Bruce Momjian <pgman@candle.pha.pa.us>
Re: Migration to version 7.4 Nabil Sayegh <postgresql@e-trolley.de>
Re: Migration to version 7.4 Bruce Momjian <pgman@candle.pha.pa.us>
Re: Migration to version 7.4 Bruce Momjian <pgman@candle.pha.pa.us>
Nabil Sayegh wrote: > Bruce Momjian wrote: > >>1) Inner joins using the explicit JOIN syntax may behave differently > >>because they are now better optimized. > >> > >>What exactly do you mean by 'may behave differently'? > > > > > > They will be fully optimized, so they might be faster. In pre-7.4, ANSI > > syntax restricted the choices researched by the optimizer. > > That's fine, but more important to me is if I need to change any queries in > my apps ;) Nope, they should just be better. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-novice по дате отправления