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 4288.1434657860@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Inheritance planner CPU and memory usage change since 9.3.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Inheritance planner CPU and memory usage change since 9.3.2
Re: Inheritance planner CPU and memory usage change since 9.3.2
Список pgsql-hackers
I wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Well, append_rel_list has an AppendRelInfo for every RTE and that
>> contains a List (translated_vars) which in turn contains a Var node
>> for every column.  I'm not sure how that compares to the RTE itself.

> RTEs also have a per-column component, namely the lists of column alias
> names.

... although I see that range_table_mutator doesn't bother to copy/change
the column alias substructure.  (Wonder if that gives rise to any
observable EXPLAIN bugs...)  But it still seems like the append_rel_list
shouldn't be all that much bulkier than all the other crap that gets
generated inside this loop.  We're not doing anything at all to reclaim
space consumed inside subquery_planner, and you'd think that would be
a lot.

By the by, the tablesample additions to range_table_mutator are obviously
broken.
        regards, tom lane



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Is it possible to have a "fast-write" Index?
Следующее
От: Eric Ridge
Дата:
Сообщение: Weirdness using Executor Hooks