Re: Rethinking TupleTableSlot deforming

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Rethinking TupleTableSlot deforming
Дата
Msg-id 11346.1469220780@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Rethinking TupleTableSlot deforming  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2016-07-22 15:00:32 -0400, Tom Lane wrote:
>> Well, it's a question of whether an extra projection at the scan level is
>> worth the savings in column access during the sort or group stage.

> Well, the projection is what I was thinking of.

One point here is that unless your test case is a blind "SELECT *",
there's almost certainly going to be a projection before a sort anyway,
because we always want to get rid of any unreferenced columns to minimize
the data volume going through the sort.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug with plpgsql handling of NULL argument of compound type
Следующее
От: David Fetter
Дата:
Сообщение: Re: [PROPOSAL] Temporal query processing with range types