Re: Where to change the column width in RelOptInfo data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 范国腾 <fanguoteng(at)highgo(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Where to change the column width in RelOptInfo data
Date: 2018-07-25 14:35:31
Message-ID: 2093.1532529331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?gb2312?B?t7a5+sza?= <fanguoteng(at)highgo(dot)com> writes:
> I use a postgres extension plugin pg_strom to generate the plan. I select one column ¡°avg(c_acctbal)¡± in the SQL, and the generated plan changes to select two column ¡°c_acctbal, c_phone¡±.

I think you'd be better off doing that sort of thing in the rewriter
somewhere. Wherever you tried to put it in the planner is clearly
too late.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2018-07-28 00:16:32 Join plan issue with inherited tables
Previous Message Scott Ribe 2018-07-25 13:41:52 Re: Granting any privilege for a specific set of tables in postgres in a single shot!..