| From: | Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com>, Floris Van Nee <florisvannee(at)optiver(dot)com> |
| Subject: | Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series) |
| Date: | 2021-02-10 03:27:25 |
| Message-ID: | CAKU4AWpUA8dyVSU1nfCJz71mu6VEjbGS1uy8azrt5CdyoZqGQA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Feb 10, 2021 at 11:18 AM Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> wrote:
> Hi:
>
> This patch is the first patch in UniqueKey patch series[1], since I need
> to revise
> that series many times but the first one would be not that often, so I'd
> like to
> submit this one for review first so that I don't need to maintain it again
> and again.
>
> v1-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch
>
> Introduce notnullattrs field in RelOptInfo to indicate which attr are not
> null
> in current query. The not null is judged by checking pg_attribute and
> query's
> restrictinfo. The info is only maintained at Base RelOptInfo and
> Partition's
> RelOptInfo level so far.
>
>
> Any thoughts?
>
> [1]
> https://www.postgresql.org/message-id/CAKU4AWr1BmbQB4F7j22G%2BNS4dNuem6dKaUf%2B1BK8me61uBgqqg%40mail.gmail.com
>
> --
> Best Regards
> Andy Fan (https://www.aliyun.com/)
>
Add the missed patch..
--
Best Regards
Andy Fan (https://www.aliyun.com/)
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Introduce-notnullattrs-field-in-RelOptInfo-to-ind.patch | application/octet-stream | 4.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2021-02-10 03:38:53 | Re: Parallel INSERT (INTO ... SELECT ...) |
| Previous Message | Andy Fan | 2021-02-10 03:18:47 | Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series) |