Re: Posible planner improvement?
От | Richard Huxton |
---|---|
Тема | Re: Posible planner improvement? |
Дата | |
Msg-id | 48341F1D.3090304@archonet.com обсуждение исходный текст |
Ответ на | Re: Posible planner improvement? ("Luke Lonergan" <LLonergan@greenplum.com>) |
Ответы |
Re: Posible planner improvement?
Re: Posible planner improvement? Re: Posible planner improvement? |
Список | pgsql-performance |
Luke Lonergan wrote: > The problem is that the implied join predicate is not being > propagated. This is definitely a planner deficiency. IIRC only equality conditions are propagated and gt, lt, between aren't. I seem to remember that the argument given was that the cost of checking for the ability to propagate was too high for the frequency when it ocurred. Of course, what was true for code and machines of 5 years ago might not be so today. -- Richard Huxton Archonet Ltd
В списке pgsql-performance по дате отправления: