Re: Should we add GUCs to allow partition pruning to be disabled?

From:	Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To:	David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Should we add GUCs to allow partition pruning to be disabled?
Date:	2018-05-09 04:14:15
Message-ID:	2a82b3a3-d42b-bd13-8b70-0c17b850c2d3@lab.ntt.co.jp
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-04-18 00:07:18 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>  2018-04-18 00:42:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com>   2018-04-18 01:03:06 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>    2018-04-18 01:12:19 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>     2018-04-18 01:47:32 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>  2018-04-18 09:36:42 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>   2018-04-18 21:24:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>    2018-04-19 04:32:54 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>     2018-04-19 11:32:45 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>      2018-04-19 12:50:02 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>       2018-04-20 02:07:45 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>        2018-04-20 02:18:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>         2018-04-20 02:33:32 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>          2018-04-20 02:41:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>           2018-04-24 16:07:11 from Jim Finnerty <jfinnert(at)amazon(dot)com>            2018-04-24 21:59:52 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>        2018-04-20 05:47:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎         2018-04-20 08:51:27 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>          2018-04-20 09:08:20 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>         2018-04-20 18:28:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>          2018-04-21 05:09:29 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎           2018-04-23 04:46:17 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>            2018-04-23 21:10:24 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>             2018-04-24 02:23:28 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>              2018-04-24 21:59:29 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>               2018-04-26 07:29:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                2018-05-01 09:44:54 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                 2018-05-01 23:18:11 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                  2018-05-02 08:07:07 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                   2018-05-02 13:29:24 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                   2018-05-07 06:00:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                    2018-05-08 13:32:05 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                     2018-05-09 02:59:15 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                      2018-05-10 02:01:55 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                       2018-05-10 02:10:20 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                        2018-05-10 02:17:24 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                        2018-05-10 14:22:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2018-05-10 14:49:31 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                          2018-05-10 19:45:12 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎                           2018-05-10 20:05:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                            2018-05-11 02:22:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                             2018-05-16 13:19:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                              2018-05-17 04:04:23 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                               2018-05-17 14:24:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2018-05-18 08:22:34 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                 2018-05-18 20:02:18 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2018-05-19 04:22:20 from Amit Langote <amitlangote09(at)gmail(dot)com>                           2018-05-11 05:37:31 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                            2018-05-12 15:30:11 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                             2018-05-14 00:55:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                              2018-05-14 01:20:06 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                            2019-03-10 09:53:02 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                             2019-03-10 15:25:57 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                              2019-03-11 01:33:21 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                               2019-03-11 02:00:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                2019-03-11 02:13:22 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                2019-03-11 02:13:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                 2019-03-11 04:06:08 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                  2019-03-11 04:22:44 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                   2019-03-11 04:30:11 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                    2019-03-12 15:07:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2019-03-12 23:28:31 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                      2019-03-13 00:39:54 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                      2019-03-13 13:10:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2019-03-20 11:51:08 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                        2019-04-11 03:34:30 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                         2019-04-11 04:06:23 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                          2019-04-11 04:50:51 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                           2019-04-11 05:00:49 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                         2019-04-11 05:40:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                          2019-04-12 02:01:39 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                           2019-04-12 02:24:28 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                      2018-05-19 01:56:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                       2018-05-23 21:35:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                        2018-05-23 22:46:38 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2018-05-23 23:31:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                          2018-05-24 02:30:40 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                           2018-05-24 05:19:15 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                            2018-06-01 18:57:22 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                        2018-06-01 19:00:10 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                         2018-06-01 21:33:00 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                          2018-07-05 21:13:39 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                           2018-07-05 21:41:28 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                            2018-07-05 21:55:06 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                             2018-07-06 01:49:50 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                              2018-07-06 19:33:55 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                    2018-05-09 04:14:15 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                     2018-05-09 08:23:23 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                 2018-05-02 23:06:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                  2018-05-02 23:38:53 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                   2018-05-02 23:52:27 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                  2018-05-10 15:57:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                   2018-05-10 16:50:25 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                    2018-05-10 16:58:49 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                     2018-05-10 17:13:24 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2018-05-10 17:38:41 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                       2018-05-10 17:51:27 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                        2018-05-10 18:05:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2018-05-11 03:59:27 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                       2018-05-11 06:36:05 from Michael Paquier <michael(at)paquier(dot)xyz>                2018-05-07 03:34:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                 2018-05-07 05:05:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>               2018-05-01 19:24:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                2018-05-01 21:14:29 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                 2018-05-01 21:29:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                2018-05-02 13:28:58 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                 2018-05-03 00:44:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2018-05-03 02:34:04 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                   2018-05-03 02:49:42 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                    2018-05-24 16:34:28 from Bruce Momjian <bruce(at)momjian(dot)us>                     2018-05-24 18:23:17 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2018-05-24 18:30:30 from Bruce Momjian <bruce(at)momjian(dot)us>             2018-04-26 02:54:42 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>        2018-04-20 06:00:14 from Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>         2018-04-20 08:49:15 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>          2018-04-20 18:19:55 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Lists:	pgsql-hackers

In response to

• Re: Should we add GUCs to allow partition pruning to be disabled? at 2018-05-07 06:00:59 from David Rowley

Responses

• Re: Should we add GUCs to allow partition pruning to be disabled? at 2018-05-09 08:23:23 from Amit Langote

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Langote	2018-05-09 05:01:26	Re: [HACKERS] path toward faster partition pruning
Previous Message	Amit Kapila	2018-05-09 03:21:20	Re: parallel.sgml for Gather with InitPlans