Join pushdown support for foreign tables

Edit

Title

Topic

Server Features

Created

2015-02-16 23:55:09

Last modified

2015-12-22 13:27:25 (8 years, 3 months ago)

Latest email

2015-11-06 04:34:17 (8 years, 5 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

Etsuro Fujita (efujita), KaiGai Kohei (kaigai), Ashutosh Bapat (ashutoshbapat)Become reviewer

Committer

Links

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