Join pushdown support for foreign tables

Edit
ID 167
Title Join pushdown support for foreign tables
Topic Server Features
Created 2015-02-16 23:55:09
Last modified 2015-12-22 13:27:25 (8 years, 9 months ago)
Latest email 2015-11-06 04:34:17 (8 years, 11 months ago)
Status
2015-11: Returned with feedback
2015-09: Moved to next CF
2015-07: Moved to next CF
2015-02: Moved to next CF
Target version
Authors Shigeru Hanada (hanada)
Reviewers KaiGai Kohei (kaigai), Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/167
git checkout commitfest/cf/167
Emails
Join push-down support for foreign tables
First at 2014-09-03 09:16:27 by Shigeru Hanada <shigeru.hanada at gmail.com>
Latest at 2015-02-16 04:53:47 by Shigeru Hanada <shigeru.hanada at gmail.com>
Latest attachment (join_pushdown.patch) at 2014-12-15 08:40:18 from Shigeru Hanada <shigeru.hanada at gmail.com>
    Attachment (join_pushdown.patch) at 2014-12-15 08:40:18 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
    Attachment (join_pushdown_wip.patch) at 2014-10-03 09:45:00 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2015-02-16 04:06:30 Shigeru Hanada (hanada) From Shigeru Hanada <shigeru.hanada@gmail.com>
at 2015-02-16 04:03:13
Revised patch.
Re: Join push-down support for foreign tables
First at 2015-02-17 01:39:02 by Kouhei Kaigai <kaigai at ak.jp.nec.com>
Latest at 2015-03-13 09:32:18 by Ashutosh Bapat <ashutosh.bapat at enterprisedb.com>
Latest attachment (pgfdw_join.sql) at 2015-03-13 09:32:18 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com>
    Attachment (pgfdw_join.sql) at 2015-03-13 09:32:18 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (add_fdw_custom_relids.patch) at 2015-03-10 03:07:29 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (explain_relnames.patch) at 2015-03-06 10:25:45 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (foreign_join_v5.patch) at 2015-03-05 15:30:17 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
    Attachment (foreign_join_v2.patch) at 2015-03-02 12:48:27 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)
First at 2015-03-23 00:12:19 by Kouhei Kaigai <kaigai at ak.jp.nec.com>
Latest at 2015-04-22 16:21:39 by Robert Haas <robertmhaas at gmail.com>
Latest attachment (pgsql-v9.5-custom-join.v12.patch) at 2015-04-22 02:33:50 from Kouhei Kaigai <kaigai at ak.jp.nec.com>
    Attachment (pgsql-v9.5-custom-join.v12.patch) at 2015-04-22 02:33:50 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (foreign_join_v9.patch) at 2015-04-07 07:42:32 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
    Attachment (foreign_join_v8.patch) at 2015-04-07 06:53:48 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
    Attachment (foreign_join_v7.patch) at 2015-04-03 10:32:08 from Shigeru Hanada <shigeru.hanada at gmail.com> (Patch: Yes)
    Attachment (pgsql-v9.5-custom-join.v11.patch) at 2015-03-26 01:51:57 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (pgsql-v9.5-custom-join.v10.patch) at 2015-03-23 00:12:19 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)
First at 2015-04-09 12:22:15 by Kouhei Kaigai <kaigai at ak.jp.nec.com>
Latest at 2015-04-10 06:00:58 by Shigeru HANADA <shigeru.hanada at gmail.com>
Latest attachment (unknown_filename) at 2015-04-10 06:00:58 from Shigeru HANADA <shigeru.hanada at gmail.com>
    Attachment (unknown_filename) at 2015-04-10 06:00:58 from Shigeru HANADA <shigeru.hanada at gmail.com> (Patch: No)
Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)
First at 2015-04-17 01:13:56 by Kouhei Kaigai <kaigai at ak.jp.nec.com>
Latest at 2015-04-29 20:12:05 by Robert Haas <robertmhaas at gmail.com>
Latest attachment (unknown_filename) at 2015-04-17 04:43:46 from Shigeru HANADA <shigeru.hanada at gmail.com>
    Attachment (unknown_filename) at 2015-04-17 04:43:46 from Shigeru HANADA <shigeru.hanada at gmail.com> (Patch: No)
Foreign join pushdown vs EvalPlanQual
First at 2015-06-24 02:40:51 by Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp>
Latest at 2015-11-06 04:34:17 by Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
Latest attachment (0001-Allow-substitute-ExecScan-body-for-ExecForignScan.patch) at 2015-11-06 04:34:17 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
    Attachment (0001-Allow-substitute-ExecScan-body-for-ExecForignScan.patch) at 2015-11-06 04:34:17 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (foreign-recheck-for-foreign-join-v2.patch) at 2015-10-19 11:35:31 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (stupid-epq-tricks.patch) at 2015-10-16 19:10:31 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (foreign-recheck-for-foreign-join-1.patch) at 2015-10-16 09:00:45 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (foreign-recheck-for-foreign-table-v2.patch) at 2015-10-14 19:21:41 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (foreign-recheck-for-foreign-table-1.patch) at 2015-10-14 08:31:16 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (pgsql-fdw-epq-recheck.v3.patch) at 2015-09-29 08:49:10 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (pgsql-fdw-epq-recheck.v2.patch) at 2015-09-28 07:34:23 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (fdw-eval-plan-qual-3.0.patch) at 2015-09-07 08:05:50 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (fdw-eval-plan-qual-2.0.patch) at 2015-09-04 10:50:46 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (fdw-eval-plan-qual-1.0.patch) at 2015-08-27 11:35:12 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (pgsql-fdw-epq-recheck.v1.patch) at 2015-08-13 01:13:18 from Kouhei Kaigai <kaigai at ak.jp.nec.com> (Patch: Yes)
    Attachment (foreign_join_v16_efujita.patch) at 2015-08-12 11:25:57 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
History
When Who What
2015-12-22 13:27:25 Michael Paquier (michael-kun) Closed in commitfest 2015-11 with status: Returned with feedback
2015-10-30 23:32:06 Michael Paquier (michael-kun) Closed in commitfest 2015-09 with status: Moved to next CF
2015-09-03 10:57:26 Andres Freund (andresfreund) Attached mail thread 558A18B3.9050201@lab.ntt.co.jp
2015-08-26 07:45:36 Michael Paquier (michael-kun) Closed in commitfest 2015-07 with status: Moved to next CF
2015-08-05 20:06:55 Heikki Linnakangas (heikki) Attached mail thread 9A28C8860F777E439AA12E8AEA7694F8010B20A3@BPXM15GP.gisp.nec.co.jp
2015-06-10 00:35:11 Shigeru Hanada (hanada) Closed in commitfest 2015-02 with status: Moved to next CF
2015-05-13 16:10:30 Robert Haas (rhaas) Closed in commitfest 2015-02 with status: Returned with feedback
2015-04-22 10:32:01 Ashutosh Bapat (ashutoshbapat) Attached mail thread 9A28C8860F777E439AA12E8AEA7694F8010D0872@BPXM15GP.gisp.nec.co.jp
2015-04-14 05:21:50 KaiGai Kohei (kaigai) New status: Ready for Committer
2015-04-10 06:08:18 Shigeru Hanada (hanada) New status: Needs review
2015-04-10 06:07:50 Shigeru Hanada (hanada) Attached mail thread 9A28C8860F777E439AA12E8AEA7694F8010CDAD4@BPXM15GP.gisp.nec.co.jp
2015-04-09 12:23:15 KaiGai Kohei (kaigai) New status: Ready for Committer
2015-04-07 07:00:08 Shigeru Hanada (hanada) Attached mail thread 9A28C8860F777E439AA12E8AEA7694F8010C5772@BPXM15GP.gisp.nec.co.jp
2015-03-05 03:27:31 Ashutosh Bapat (ashutoshbapat) Added ashutosh_bapat as reviewer
2015-02-20 07:05:55 Etsuro Fujita (efujita) Changed reviewers to KaiGai Kohei (kaigai), Etsuro Fujita (efujita)
2015-02-16 23:55:47 Michael Paquier (michael-kun) Changed authors to Shigeru Hanada (hanada)
2015-02-16 23:55:47 Michael Paquier (michael-kun) Changed reviewers to KaiGai Kohei (kaigai)
2015-02-16 23:55:09 Michael Paquier (michael-kun) Attached mail thread CAEZqfEeDxaebJNM3ukcJdCezFqqiY3VD+ctEfjSW=PrsenemQw@mail.gmail.com
2015-02-16 23:55:09 Michael Paquier (michael-kun) Created patch record
Edit