Tom Lane wrote:
Uh, why would you see that?  The planner would never generate an
IndexOnlyScan in the first place if the query required any columns
not available from the index.


True, but as you can see, create_append_plan() produces its own targetlist:

static Plan *
create_append_plan(PlannerInfo *root, AppendPath *best_path)
{
        Append     *plan;
        List       *tlist = build_path_tlist(root, &best_path->path);
        ...

If we replace Append with some custom node, the plan will instantly become invalid (it won't be be able to build a projection from 'custom_scan_tlist' to 'targetlist'). However, this doesn't mean that it's unable to produce the same result.


--
Dmitry Ivanov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to