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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Slemko <marcs(at)znep(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance of SELECT * much faster than SELECT <colname> with large offset
Date: 2014-10-03 02:39:37
Message-ID: 10064.1412303977@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marc Slemko <marcs(at)znep(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marti Raudsepp 2014-10-03 08:40:04 Re: performance of SELECT * much faster than SELECT <colname> with large offset
Previous Message Marc Slemko 2014-10-03 02:17:48 performance of SELECT * much faster than SELECT <colname> with large offset