Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw
Date
Msg-id CAMkU=1z1H0v_9JTMVVqS3Z8mNnY-VSW2WOrOgQ+w42YQ1LC8Vw@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Wed, Jan 18, 2017 at 5:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
jeff.janes@gmail.com writes:
> The "Output:" line of explain verbose lists columns of foreign table that
> are not actually output, or at least ought not be output.

That's an optimization to avoid an unnecessary projection step.  It has
nothing to do with what's retrieved from the remote, and for that matter
it's not specific to foreign tables.

Is all of that data actually being transferred from the foreign to the local?  If so, I don't think the optimization is a good choice in this case.  Do you know where can I find the relevant source code which decides on this?
 
Cheers,

Jeff

pgsql-bugs by date:

Previous
From: yoonghm@gmail.com
Date:
Subject: [BUGS] BUG #14507: Update start-scripts/linux for missing LSG tags andoverrides
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw