Re: [HACKERS] Runtime Partition Pruning

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc:	David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Beena Emerson <memissemerson(at)gmail(dot)com>, amul sul <sulamul(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Subject:	Re: [HACKERS] Runtime Partition Pruning
Date:	2018-04-24 17:10:57
Message-ID:	20180424171057.5uls2dlyuxhdljw4@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2017-09-26 04:01:30 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎  2017-11-09 11:18:36 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎   2017-11-09 15:31:57 from Robert Haas <robertmhaas(at)gmail(dot)com>    2017-11-10 02:03:43 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2017-11-10 11:03:58 from amul sul <sulamul(at)gmail(dot)com>    2017-11-14 06:15:11 from Beena Emerson <memissemerson(at)gmail(dot)com>     2017-11-14 06:16:04 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎      2017-11-14 08:52:07 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>       2017-11-15 06:49:42 from Beena Emerson <memissemerson(at)gmail(dot)com>       2017-11-29 11:35:23 from Beena Emerson <memissemerson(at)gmail(dot)com>      2017-11-14 12:57:02 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>       2017-11-14 23:13:21 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>        2017-11-15 00:53:35 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>        2017-11-15 06:53:42 from Beena Emerson <memissemerson(at)gmail(dot)com>         2017-11-29 01:41:55 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>          2017-11-29 11:35:11 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎          2017-11-30 05:16:32 from Beena Emerson <memissemerson(at)gmail(dot)com>        2017-11-16 09:08:16 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>        2017-11-29 11:35:39 from Beena Emerson <memissemerson(at)gmail(dot)com>         2017-12-01 11:20:47 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎          2017-12-01 19:04:37 from Robert Haas <robertmhaas(at)gmail(dot)com>           2017-12-02 08:33:22 from Beena Emerson <memissemerson(at)gmail(dot)com>            2017-12-04 02:06:23 from Robert Haas <robertmhaas(at)gmail(dot)com>           2017-12-06 07:51:15 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>            2017-12-07 07:22:43 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎             2017-12-07 10:37:51 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>              2017-12-07 10:56:14 from Beena Emerson <memissemerson(at)gmail(dot)com>               2017-12-07 22:07:28 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                2017-12-12 11:34:26 from Beena Emerson <memissemerson(at)gmail(dot)com>             2017-12-07 11:17:26 from Beena Emerson <memissemerson(at)gmail(dot)com>             2017-12-08 15:57:12 from Robert Haas <robertmhaas(at)gmail(dot)com>              2017-12-12 11:27:10 from Beena Emerson <memissemerson(at)gmail(dot)com>               2017-12-12 11:33:29 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎                2017-12-16 06:05:57 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                 2017-12-18 08:31:20 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                  2017-12-18 10:33:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                   2017-12-19 08:54:26 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎                    2017-12-21 09:01:48 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                     2017-12-21 10:51:57 from Beena Emerson <memissemerson(at)gmail(dot)com>                      2017-12-21 12:31:04 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2017-12-21 12:43:31 from Beena Emerson <memissemerson(at)gmail(dot)com> 📎                        2017-12-21 13:00:26 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2017-12-21 13:06:04 from Beena Emerson <memissemerson(at)gmail(dot)com>                          2017-12-21 13:32:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                     2017-12-21 12:56:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                      2017-12-21 14:02:29 from Beena Emerson <memissemerson(at)gmail(dot)com>                       2017-12-21 14:28:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2017-12-21 23:49:23 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                      2017-12-27 03:06:44 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                       2018-01-01 06:22:39 from Beena Emerson <memissemerson(at)gmail(dot)com>                        2018-01-01 13:34:21 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                         2018-01-04 16:37:08 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                          2018-01-04 23:58:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                           2018-01-05 02:00:48 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2018-01-05 00:54:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                           2018-01-05 18:31:45 from Beena Emerson <memissemerson(at)gmail(dot)com>                            2018-01-06 11:03:54 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                             2018-01-07 12:01:30 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                              2018-01-09 08:54:54 from Beena Emerson <memissemerson(at)gmail(dot)com>                               2018-01-09 09:22:07 from Beena Emerson <memissemerson(at)gmail(dot)com>                                2018-01-09 22:41:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                2018-01-10 01:51:51 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                 2018-02-17 08:57:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                  2018-02-20 10:46:32 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                                   2018-02-21 00:44:00 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                    2018-02-21 09:06:32 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                     2018-02-21 09:45:44 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                                      2018-02-21 11:58:31 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                     2018-02-22 09:31:23 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                      2018-02-22 12:15:26 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                       2018-02-22 15:11:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                        2018-02-23 02:07:38 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                      2018-02-23 11:34:19 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                       2018-02-27 09:39:47 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                                        2018-02-27 09:50:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                         2018-03-01 13:04:41 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                          2018-03-01 18:17:24 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                           2018-03-02 01:29:42 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                            2018-03-09 18:50:54 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                             2018-03-31 13:52:09 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                              2018-03-31 15:41:32 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2018-04-03 17:44:37 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> 📎                                               2018-04-03 17:50:35 from Beena Emerson <memissemerson(at)gmail(dot)com>                                                2018-04-04 02:27:08 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                 2018-04-04 04:48:08 from Beena Emerson <memissemerson(at)gmail(dot)com>                                               2018-04-04 02:10:54 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                2018-04-04 02:31:17 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                2018-04-04 06:27:48 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                 2018-04-04 07:04:17 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                  2018-04-04 07:20:10 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                2018-04-04 17:31:31 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                                 2018-04-05 02:01:46 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                  2018-04-05 12:46:01 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                              2018-04-05 03:14:03 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                               2018-04-05 06:54:39 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                               2018-04-05 12:54:41 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                2018-04-05 13:41:30 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                 2018-04-05 19:47:12 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                                 2018-04-06 02:39:07 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                  2018-04-06 03:27:16 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                   2018-04-06 04:51:58 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                2018-04-06 10:46:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                 2018-04-06 21:25:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                  2018-04-06 21:29:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                   2018-04-06 22:45:21 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                    2018-04-07 00:03:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                     2018-04-07 02:26:25 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                      2018-04-07 04:26:51 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                       2018-04-07 04:31:08 from Andres Freund <andres(at)anarazel(dot)de>                                                        2018-04-07 04:58:01 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                         2018-04-07 04:59:50 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                         2018-04-07 05:01:04 from Andres Freund <andres(at)anarazel(dot)de>                                                        2018-04-07 04:58:39 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                         2018-04-07 05:49:16 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                          2018-04-07 12:23:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                           2018-04-07 12:33:37 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                            2018-04-07 13:18:03 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                             2018-04-07 13:22:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                              2018-04-07 13:41:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                       2018-04-07 04:46:42 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                       2018-04-07 08:45:58 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                        2018-04-07 13:55:19 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                                        2018-04-07 21:13:31 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                         2018-04-07 21:20:16 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                         2018-04-09 16:06:43 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2018-04-09 18:28:47 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                           2018-04-09 18:44:18 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                            2018-04-09 18:48:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                            2018-04-10 21:32:03 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                             2018-04-11 06:12:52 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                             2018-04-12 04:40:12 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                              2018-04-12 16:57:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                               2018-04-12 22:01:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                2018-04-13 17:04:03 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                 2018-04-17 00:11:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                  2018-04-17 02:33:43 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                   2018-04-17 02:46:45 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                    2018-04-18 15:13:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                     2018-04-19 00:04:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                      2018-04-19 00:05:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                      2018-04-19 05:41:47 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                                                       2018-04-24 14:19:04 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                                        2018-04-24 17:10:57 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                         2018-04-25 23:17:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                      2018-04-24 01:57:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                      2018-04-24 17:16:11 from Andres Freund <andres(at)anarazel(dot)de>                                                                       2018-04-24 18:21:50 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                        2018-04-25 23:17:38 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                               2018-04-13 05:38:46 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                                2018-04-13 05:48:42 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                                 2018-04-13 05:58:34 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> 📎                                                             2019-05-24 14:50:04 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>                                                              2019-05-24 15:20:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                               2019-05-24 15:34:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2019-05-24 15:58:18 from Andres Freund <andres(at)anarazel(dot)de>                                                                 2019-05-24 16:08:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2019-05-24 16:24:28 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2019-05-24 22:42:39 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                                                    2019-05-27 14:04:41 from Andres Freund <andres(at)anarazel(dot)de>                                                                  2019-05-29 21:03:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                   2019-05-29 22:02:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2019-05-29 22:07:52 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2018-02-22 15:11:52 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>                                      2018-02-23 11:40:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                       2018-02-23 12:04:48 from Simon Riggs <simon(at)2ndquadrant(dot)com>                                        2018-02-26 04:13:14 from Amit Langote <amitlangote09(at)gmail(dot)com>                                       2018-02-26 04:15:28 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                     2017-12-21 23:45:15 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2017-12-21 23:53:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2017-12-22 01:29:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2017-12-22 01:37:49 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2017-12-22 15:42:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2020-10-04 07:10:54 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                           2020-10-07 09:05:36 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                            2020-10-07 13:30:42 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                             2020-10-08 11:25:14 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                              2020-10-12 02:28:48 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                               2020-10-12 09:47:50 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                2020-10-12 12:22:45 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                              2020-10-13 07:48:04 from Amit Langote <amitlangote09(at)gmail(dot)com>                               2020-10-14 00:40:13 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                 2017-12-19 08:44:57 from Beena Emerson <memissemerson(at)gmail(dot)com>              2017-12-18 08:51:02 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>             2017-12-12 10:34:53 from Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>              2017-12-12 11:35:29 from Beena Emerson <memissemerson(at)gmail(dot)com>       2017-11-29 11:35:31 from Beena Emerson <memissemerson(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: [HACKERS] Runtime Partition Pruning at 2018-04-24 14:19:04 from Alvaro Herrera

Responses

• Re: [HACKERS] Runtime Partition Pruning at 2018-04-25 23:17:59 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Geoghegan	2018-04-24 17:12:28	Re: Corrupted btree index on HEAD because of covering indexes
Previous Message	Konstantin Knizhnik	2018-04-24 17:00:00	Re: Built-in connection pooling