Re: performance of SELECT * much faster than SELECT with large offset - Mailing list pgsql-performance

From Tom Lane
Subject Re: performance of SELECT * much faster than SELECT with large offset
Date
Msg-id 10064.1412303977@sss.pgh.pa.us
Whole thread Raw
In response to performance of SELECT * much faster than SELECT with large offset  (Marc Slemko <marcs@znep.com>)
Responses Re: performance of SELECT * much faster than SELECT with large offset  (Marti Raudsepp <marti@juffo.org>)
List 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 by date:

Previous
From: Marc Slemko
Date:
Subject: performance of SELECT * much faster than SELECT with large offset
Next
From: Marti Raudsepp
Date:
Subject: Re: performance of SELECT * much faster than SELECT with large offset