How far are projections pushed down the execution tree?

Поиск
Список
Период
Сортировка
От tmp
Тема How far are projections pushed down the execution tree?
Дата
Msg-id hmiper$1sua$1@news.hub.org
обсуждение исходный текст
Ответы Re: How far are projections pushed down the execution tree?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Consider a table and a query referring to only a subset of the columns 
in that table. How early in the query evaluation is the projection 
carried out?

Are the columns to be selected filtered out as early as in the very 
access method that reads the table rows from the buffer, or are the 
projection handled later, after the whole row has been fetched by the 
access method?

Does it depend on the complexity of the query, how far down the three 
that the projection is handled out?

Thanks!


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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: dedebugging and a functions that just don't work on debian flavour
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: How far are projections pushed down the execution tree?