Marc Slemko <marcs@xxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance