Re: performance of SELECT * much faster than SELECT with large offset

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance of SELECT * much faster than SELECT with large offset
Дата
Msg-id 10064.1412303977@sss.pgh.pa.us
обсуждение исходный текст
Ответ на performance of SELECT * much faster than SELECT with large offset  (Marc Slemko <marcs@znep.com>)
Ответы Re: performance of SELECT * much faster than SELECT with large offset  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-performance
Дерево обсуждения 
Marc Slemko <marcs@znep.com> writes:
> I ran into this oddity lately that goes against everything I thought I
> understood and was wondering if anyone had any insight.

SELECT * avoids a projection step ... see ExecAssignScanProjectionInfo.

            regards, tom lane

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

Предыдущее
От: Marc Slemko
Дата:
Сообщение: performance of SELECT * much faster than SELECT with large offset
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: performance of SELECT * much faster than SELECT with large offset