Re: Inheritance planner CPU and memory usage change since 9.3.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Inheritance planner CPU and memory usage change since 9.3.2
Дата
Msg-id 593.1434904159@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Inheritance planner CPU and memory usage change since 9.3.2  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> However, there's an obvious improvement that can be made to Tom's
> patch -- having computed modifiableARIindexes, you may as well use it
> in the innermost loop to only apply ChangeVarNodes() to those
> AppendRelInfo's that can actually change, rather than having it trawl
> through all the other ones that we know won't be touched.

Right.  Also, as Robert noted, we can short-circuit a few more things when
there are no subquery RTEs.  I'll combine these ideas and push something,
but probably not till tomorrow.
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pg_stat_*_columns?
Следующее
От: Andres Freund
Дата:
Сообщение: Backpatch src/test/modules to 9.3?