Re: Materialize Subplan and push into inner index conditions

От: Tom Lane
Тема: Re: Materialize Subplan and push into inner index conditions
Дата: ,
Msg-id: 16084.1136303014@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Materialize Subplan and push into inner index conditions  (Jens-Wolfhard Schicke)
Список: pgsql-performance

Jens-Wolfhard Schicke <> writes:
> Is it possible to have the planner consider the second plan instead of the
> first?

At the moment, only if you get rid of the inheritance.  The planner's
not very smart at all when faced with joining inheritance trees.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Materialize Subplan and push into inner index conditions
От: Steve Eckmann
Дата:
Сообщение: improving write performance for logging application