Re: [PoC] Reducing planning time when tables have many partitions

From:	Yuya Watari <watari(dot)yuya(at)gmail(dot)com>
To:	David Rowley <dgrowleyml(at)gmail(dot)com>
Cc:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: [PoC] Reducing planning time when tables have many partitions
Date:	2022-11-02 09:27:52
Message-ID:	CAJ2pMkawnReiHswhVixs1veUY7Sxp8Q8dTz7q_m8LoAdBnL5rg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-03-18 10:24:56 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎  2022-03-24 02:03:38 from David Rowley <dgrowleyml(at)gmail(dot)com>   2022-06-22 09:05:43 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎    2022-07-03 21:28:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2022-07-05 08:57:14 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎      2022-07-21 11:35:49 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>       2022-07-22 09:16:51 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>     2022-07-27 03:31:08 from David Rowley <dgrowleyml(at)gmail(dot)com>      2022-07-27 06:07:03 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>       2022-07-27 21:35:10 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎        2022-08-08 11:27:46 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎         2022-08-09 07:10:00 from David Rowley <dgrowleyml(at)gmail(dot)com>          2022-08-16 08:26:41 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎           2022-08-26 00:39:32 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎            2022-08-26 03:18:30 from David Rowley <dgrowleyml(at)gmail(dot)com>             2022-08-26 08:53:34 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>              2022-09-21 09:43:51 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎               2022-10-24 04:12:51 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                2022-11-02 09:27:52 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                 2022-11-07 06:21:14 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                  2022-11-07 06:25:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2022-11-07 06:32:59 from Zhang Mingli <zmlpostgres(at)gmail(dot)com>                    2022-11-16 16:44:58 from Thom Brown <thom(at)linux(dot)com>                     2022-11-17 09:31:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                      2022-11-17 11:20:48 from Thom Brown <thom(at)linux(dot)com>                       2022-11-17 12:04:46 from Thom Brown <thom(at)linux(dot)com>                        2022-11-29 08:58:25 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                         2022-12-04 00:34:44 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                          2022-12-05 15:44:59 from Thom Brown <thom(at)linux(dot)com>                           2022-12-05 21:27:55 from David Rowley <dgrowleyml(at)gmail(dot)com>                            2022-12-06 11:16:01 from Thom Brown <thom(at)linux(dot)com>                             2022-12-07 11:30:24 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                              2022-12-12 04:50:09 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                               2023-01-27 03:48:30 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                2023-01-30 10:02:37 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                 2023-01-30 12:14:28 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                  2023-02-06 01:47:33 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                   2023-02-14 10:01:41 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                    2023-02-17 08:31:45 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                     2023-03-08 12:34:23 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                      2023-03-08 21:23:28 from David Rowley <dgrowleyml(at)gmail(dot)com>                                       2023-03-10 08:38:46 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                        2023-07-05 09:57:56 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                         2023-07-27 07:58:16 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                          2023-07-28 04:27:40 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                           2023-07-28 08:49:04 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                           2023-07-28 09:50:57 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> 📎                                            2023-08-02 06:40:39 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                             2023-08-02 09:43:19 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                              2023-08-03 06:08:32 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                             2023-08-03 13:29:07 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                              2023-08-07 08:19:06 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                               2023-08-07 08:51:52 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                2023-08-07 12:15:22 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                 2023-08-08 03:22:49 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                  2023-08-08 06:19:40 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                   2023-08-09 08:14:56 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                    2023-08-09 11:54:26 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                     2023-08-10 10:03:43 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                      2023-08-25 07:39:16 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                       2023-09-07 06:43:15 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                       2023-09-19 08:21:15 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                        2023-09-20 10:04:46 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                         2023-09-20 11:03:09 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                         2023-09-22 03:48:38 from "Lepikhov Andrei" <a(dot)lepikhov(at)postgrespro(dot)ru>                                                          2023-09-27 07:28:46 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                           2023-11-17 21:04:12 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                                                            2023-11-18 02:45:51 from John Naylor <johncnaylorls(at)gmail(dot)com>                                                             2023-11-18 03:13:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                              2023-11-18 23:57:34 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                                                           2023-11-20 04:45:42 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                            2023-11-22 05:32:04 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                             2023-11-30 04:18:57 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                              2023-12-13 06:21:57 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                               2023-12-16 15:41:27 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                                                                2024-01-17 09:33:42 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                                 2024-02-12 21:19:21 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                                                                  2024-02-28 11:18:18 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                                   2024-03-06 14:16:38 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                    2024-05-02 07:56:41 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                                     2024-05-02 14:35:25 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                      2024-05-16 02:44:45 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com>                                                                       2024-08-29 05:34:46 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                                        2024-10-01 02:35:05 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                                                         2024-10-15 03:20:04 from Yuya Watari <watari(dot)yuya(at)gmail(dot)com> 📎                                         2023-08-09 10:28:07 from David Rowley <dgrowleyml(at)gmail(dot)com>                                          2023-08-09 10:37:33 from David Rowley <dgrowleyml(at)gmail(dot)com>                 2022-11-08 11:31:04 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v8-0001-Apply-eclass_member_speedup_v3.patch.patch	application/octet-stream	88.3 KB
v8-0002-Revert-one-of-the-optimizations.patch	application/octet-stream	2.0 KB
v8-0003-Use-conventional-algorithm-for-smaller-size-cases.patch	application/octet-stream	2.8 KB

In response to

• Re: [PoC] Reducing planning time when tables have many partitions at 2022-10-24 04:12:51 from Yuya Watari

Responses

• Re: [PoC] Reducing planning time when tables have many partitions at 2022-11-07 06:21:14 from Andrey Lepikhov
• Re: [PoC] Reducing planning time when tables have many partitions at 2022-11-08 11:31:04 from Andrey Lepikhov

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2022-11-02 10:02:28	Re: create subscription - improved warning message
Previous Message	Drouvot, Bertrand	2022-11-02 08:58:36	Re: Split index and table statistics into different types of stats