Re: Ordered Partitioned Table Scans

From:	David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To:	Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc:	Antonin Houska <ah(at)cybertec(dot)at>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Ordered Partitioned Table Scans
Date:	2019-01-31 03:29:56
Message-ID:	CAKJS1f-BfCEJVGc9iSbsQFqryagFfg1yByA5iXuKTX-GAXGEVg@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2018-10-26 02:50:10 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎  2018-10-26 03:52:27 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>   2018-10-26 04:39:47 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>    2018-10-26 11:01:30 from Julien Rouhaud <rjuju123(at)gmail(dot)com>     2018-10-27 14:49:07 from Julien Rouhaud <rjuju123(at)gmail(dot)com>      2018-10-29 00:44:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎       2018-10-29 10:22:17 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>       2018-10-30 23:24:59 from Julien Rouhaud <rjuju123(at)gmail(dot)com>        2018-10-31 00:05:55 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>         2018-10-31 06:36:06 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎          2018-10-31 15:01:45 from Antonin Houska <ah(at)cybertec(dot)at>           2018-11-01 03:14:11 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎            2018-11-01 09:05:38 from Antonin Houska <ah(at)cybertec(dot)at>             2018-11-04 21:46:57 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>              2018-11-22 10:27:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎               2018-12-19 07:40:55 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                2018-12-19 09:51:01 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                 2018-12-19 10:26:14 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                  2018-12-19 12:17:58 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                   2018-12-19 12:58:03 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                    2018-12-19 14:01:14 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                     2018-12-19 20:48:05 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                      2018-12-19 22:07:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2018-12-20 05:20:18 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                        2019-01-06 03:24:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2019-01-06 11:40:28 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                         2019-01-31 03:29:56 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                          2019-02-04 04:58:51 from Michael Paquier <michael(at)paquier(dot)xyz>                          2019-02-24 07:49:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                       2019-03-05 18:16:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2019-03-06 00:10:43 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                     2019-03-23 16:18:11 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                      2019-03-24 10:00:39 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>               2019-03-04 14:04:31 from Antonin Houska <ah(at)cybertec(dot)at>                2019-03-05 01:38:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                 2019-03-08 20:14:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2019-03-08 21:20:39 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                   2019-03-08 21:52:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2019-03-09 01:09:20 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                    2019-03-22 14:30:27 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                     2019-03-22 15:12:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2019-03-22 15:28:51 from Simon Riggs <simon(at)2ndquadrant(dot)com>                       2019-03-22 15:38:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2019-03-22 15:48:02 from Simon Riggs <simon(at)2ndquadrant(dot)com>                      2019-03-22 15:35:09 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                       2019-03-22 15:56:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2019-03-22 16:16:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2019-03-22 16:20:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2019-03-22 16:38:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2019-03-22 16:40:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2019-03-22 18:19:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2019-03-22 21:37:26 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                          2019-03-23 03:05:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                           2019-03-23 06:42:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2019-03-24 10:05:58 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                             2019-03-25 20:03:45 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                              2019-03-26 02:12:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                               2019-03-26 11:22:26 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                2019-03-27 00:18:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                 2019-03-27 06:48:33 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                  2019-03-27 08:23:51 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                   2019-03-27 23:04:41 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                    2019-03-28 11:00:00 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                     2019-03-28 22:59:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                      2019-04-02 01:26:32 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                       2019-04-02 11:48:39 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                        2019-04-02 12:26:26 from Amit Langote <amitlangote09(at)gmail(dot)com>                                         2019-04-02 18:10:28 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                          2019-04-03 01:01:19 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                           2019-04-03 05:46:56 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                            2019-04-03 09:28:37 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                            2019-04-05 23:26:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                             2019-04-06 00:45:25 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                              2019-04-06 09:06:30 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                               2019-04-08 05:21:11 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                  2019-03-27 22:29:14 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                   2019-03-28 01:34:43 from Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>                                    2019-03-28 02:40:56 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                     2019-03-28 04:53:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                        2019-03-23 02:59:58 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                  2019-03-09 06:51:57 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                   2019-03-15 15:22:05 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                    2019-03-15 16:44:40 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                  2019-03-15 15:49:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v7-0001-Allow-Append-to-be-used-in-place-of-MergeAppend-f.patch	application/octet-stream	58.3 KB

In response to

• Re: Ordered Partitioned Table Scans at 2019-01-06 03:24:24 from David Rowley

Responses

• Re: Ordered Partitioned Table Scans at 2019-02-04 04:58:51 from Michael Paquier
• Re: Ordered Partitioned Table Scans at 2019-02-24 07:49:34 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David G. Johnston	2019-01-31 03:35:00	Re: psql exit status with multiple -c or -f
Previous Message	Tom Lane	2019-01-31 03:07:55	Re: Proposed refactoring of planner header files