Re: [HACKERS] advanced partition matching algorithm for partition-wise join

From:	amul sul <sulamul(at)gmail(dot)com>
To:	Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: [HACKERS] advanced partition matching algorithm for partition-wise join
Date:	2019-12-09 09:38:53
Message-ID:	CAAJ_b96twc4-J2bxM8UyUZWeNjhnb85Wk4cWz17yBVLMwH_iOQ@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2017-08-21 07:13:16 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎  2017-08-28 07:14:15 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> 📎   2017-09-01 19:12:03 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎    2017-09-04 12:30:13 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> 📎     2017-09-05 11:04:18 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎      2017-09-05 11:55:03 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>      2017-09-07 14:04:14 from Antonin Houska <ah(at)cybertec(dot)at>       2017-09-11 08:08:21 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>        2017-10-11 11:08:23 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎         2017-10-12 16:16:59 from Robert Haas <robertmhaas(at)gmail(dot)com>          2017-10-13 02:29:16 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>           2017-12-03 11:23:36 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎            2018-02-07 04:51:58 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎             2018-02-08 02:55:20 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>              2018-02-08 05:11:07 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>               2018-02-09 05:31:58 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                2018-02-09 05:56:28 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                 2018-02-09 06:05:38 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>              2018-02-09 05:27:40 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎               2018-02-15 09:11:20 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                2018-02-16 05:14:32 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                 2018-02-23 14:05:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2018-02-26 10:03:21 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                   2018-03-11 19:34:33 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                    2018-03-12 05:00:54 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                     2018-03-21 23:02:02 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                      2018-03-22 13:18:40 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                       2018-03-28 21:23:09 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                        2018-03-30 14:06:22 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                         2018-04-03 13:34:45 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                          2018-05-06 19:36:56 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                           2018-05-14 11:14:23 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                            2018-06-26 08:57:03 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                             2018-06-26 09:02:21 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                              2018-06-27 06:58:20 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                               2018-06-27 13:21:50 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                                2018-06-28 05:53:40 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                 2018-07-15 17:43:43 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                  2018-07-16 15:01:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2018-07-17 09:58:23 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> 📎                                   2018-07-19 19:04:22 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                    2018-07-19 21:43:49 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                     2018-07-23 08:38:44 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                                      2018-07-26 15:07:32 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                       2018-07-27 07:17:04 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                                        2018-07-27 18:13:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2018-08-23 10:31:47 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                          2018-08-29 07:32:11 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                                           2018-08-30 08:53:32 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                            2018-08-31 06:23:56 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>                                             2018-09-12 20:14:52 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                              2018-09-17 09:20:21 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                               2018-10-25 21:19:09 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                2018-11-25 20:04:29 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                 2018-11-25 21:06:36 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                                                  2018-11-26 12:41:06 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                   2018-11-26 16:03:57 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                    2019-01-21 11:56:16 from amul sul <sulamul(at)gmail(dot)com>                                                     2019-01-21 12:09:38 from Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>                                                      2019-01-22 12:38:16 from Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                       2019-01-31 11:53:15 from Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                        2019-02-04 05:35:06 from amul sul <sulamul(at)gmail(dot)com> 📎                                                         2019-03-05 10:14:32 from amul sul <sulamul(at)gmail(dot)com> 📎                                                          2019-03-07 06:24:04 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                                                           2019-03-07 07:32:55 from amul sul <sulamul(at)gmail(dot)com>                                                            2019-03-07 14:50:10 from amul sul <sulamul(at)gmail(dot)com> 📎                                                             2019-03-08 08:42:59 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                                                             2019-03-11 02:58:54 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                              2019-03-11 05:09:46 from amul sul <sulamul(at)gmail(dot)com>                                                               2019-03-11 16:43:51 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                2019-04-24 11:26:06 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                 2019-04-26 10:29:31 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                                                                 2019-05-14 04:23:36 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                                  2019-05-14 04:29:33 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                                   2019-05-14 14:11:39 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                  2019-05-17 12:20:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                   2019-07-01 09:49:13 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                                                                    2019-07-01 11:16:30 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                     2019-07-02 04:47:17 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                      2019-07-03 06:44:16 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                       2019-07-08 11:33:32 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                        2019-07-18 06:55:36 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                         2019-07-19 13:43:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                          2019-07-30 09:00:33 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                           2019-07-31 05:47:41 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                                            2019-08-01 10:36:05 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                           2019-08-16 13:25:10 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                            2019-08-28 10:22:04 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                             2019-08-28 10:26:49 from amul sul <sulamul(at)gmail(dot)com>                                                                             2019-09-02 05:08:02 from amul sul <sulamul(at)gmail(dot)com>                                                                              2019-09-24 15:59:57 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                               2019-10-16 12:50:17 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                2019-10-25 09:59:03 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                                 2019-10-29 10:29:32 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                  2019-10-31 09:49:26 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                   2019-11-01 10:28:29 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                    2019-11-05 13:14:50 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                                     2019-11-06 06:11:47 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                                      2019-11-13 04:16:45 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                       2019-11-15 05:20:39 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                                        2019-11-15 09:10:25 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                         2019-11-22 13:08:15 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                          2019-11-29 03:45:35 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                           2019-12-09 09:38:53 from amul sul <sulamul(at)gmail(dot)com> 📎                                                                                            2019-12-10 06:49:08 from amul sul <sulamul(at)gmail(dot)com>                                                                                             2019-12-10 10:30:34 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                              2020-01-15 14:41:00 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                               2020-01-28 04:39:03 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> 📎                                                                                                2020-01-29 12:15:17 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                 2020-02-05 12:51:13 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                  2020-02-05 17:03:43 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                                   2020-02-07 12:53:24 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                  2020-02-05 18:55:32 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                                                                   2020-02-07 12:57:21 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                    2020-02-10 11:46:01 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                     2020-03-03 16:48:40 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> 📎                                                                                                      2020-03-17 08:14:39 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                       2020-03-23 13:41:54 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                                                        2020-03-24 18:03:11 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                         2020-03-25 19:05:13 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                                                                          2020-03-26 00:17:17 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                                                                                                           2020-04-01 16:51:17 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com> 📎                                                                                                            2020-04-02 03:08:57 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                          2020-04-01 17:12:01 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>                                                                                                           2020-04-03 15:15:36 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                            2020-04-06 08:28:52 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                             2020-04-06 11:45:34 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com> 📎                                                                                                             2020-04-07 15:15:21 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                                                                              2020-04-07 17:24:28 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                               2020-04-08 01:36:58 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                                2020-04-08 05:09:18 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>                                                                                                                2020-04-08 07:30:14 from Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>                                                                                                                 2020-04-08 10:12:09 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎                                                                                                                  2020-04-08 10:18:53 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>                                                                                                                   2020-04-08 15:06:19 from Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>                                                                                                                    2020-04-09 04:59:22 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                                     2020-04-09 05:36:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                      2020-04-09 06:33:29 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                                       2020-04-09 14:04:01 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                                                                        2020-04-09 14:41:00 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                                                                                        2020-04-10 15:14:22 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                                                                                                                         2020-04-10 15:20:37 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>                                                                                                                          2020-04-10 15:44:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                           2020-04-10 15:51:36 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> 📎                                                                                                                            2020-04-10 15:59:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                                             2020-04-11 04:02:11 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                                                                 2020-04-08 10:14:28 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com> 📎                                                                                                            2020-04-06 11:43:15 from Ashutosh Bapat <ashutosh(dot)bapat(at)2ndquadrant(dot)com>                                                                                                             2020-04-16 09:20:53 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                             2019-09-03 21:10:50 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                                              2019-09-05 04:23:28 from amul sul <sulamul(at)gmail(dot)com>                                                                               2019-09-05 07:10:44 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                                                                        2019-07-19 11:09:19 from amul sul <sulamul(at)gmail(dot)com>                                                                         2019-07-30 07:57:55 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v29-0001-Improve-partition-matching-for-partitionwise-join.patch	application/octet-stream	302.9 KB
v29-0002-Modify-merge_null_partitions.patch	application/octet-stream	42.7 KB

In response to

• Re: [HACKERS] advanced partition matching algorithm for partition-wise join at 2019-11-29 03:45:35 from Etsuro Fujita

Responses

• Re: [HACKERS] advanced partition matching algorithm for partition-wise join at 2019-12-10 06:49:08 from amul sul

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Eisentraut	2019-12-09 10:37:54	remove support for old Python versions
Previous Message	Rushabh Lathia	2019-12-09 09:22:34	Re: backup manifests