Reducing planning time when tables have many partitions

Title

Topic

Performance

Created

2022-06-22 08:41:43

Last modified

2023-01-31 16:16:27 (6 days, 16 hours ago)

Latest email

2023-02-06 01:47:33 (1 day, 6 hours ago)

Status

2023-03: Needs review

2023-01: Moved to next CF

2022-11: Moved to next CF

2022-09: Moved to next CF

2022-07: Moved to next CF

Target version

Authors

Yuya Watari (watari)

Reviewers

Thom Brown (thom), Andrey Lepikhov (lepikhov)Become reviewer

Committer

Links

Emails

[PoC] Reducing planning time when tables have many partitions: First at 2022-03-18 10:24:56 by Yuya Watari <watari.yuya at gmail.com>
Latest at 2023-02-06 01:47:33 by Yuya Watari <watari.yuya at gmail.com>
Latest attachment (v16-0001-Adjust-bms_int_members-so-that-it-shortens-the-l.patch) at 2023-02-06 01:47:33 from Yuya Watari <watari.yuya at gmail.com>
    Attachment (v16-0001-Adjust-bms_int_members-so-that-it-shortens-the-l.patch) at 2023-02-06 01:47:33 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Adjust-bms_int_members-so-that-it-shortens-the-l.patch) at 2023-01-30 12:14:28 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-Bitmapset-indexes-for-faster-lookup-of-Equiv.patch) at 2023-01-30 10:02:37 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-Bitmapset-indexes-for-faster-lookup-of-Equiv.patch) at 2023-01-27 03:48:30 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-Bitmapset-indexes-for-faster-lookup-of-Equiv.patch) at 2022-12-12 04:50:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (figure.png) at 2022-12-07 11:30:24 from Yuya Watari <watari.yuya at gmail.com> (Patch: No)
    Attachment (v10-0001-Add-Bitmapset-indexes-for-faster-lookup-of-Equiv.patch) at 2022-12-04 00:34:44 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Apply-eclass_member_speedup_v3.patch.patch) at 2022-11-29 08:58:25 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Apply-eclass_member_speedup_v3.patch.patch) at 2022-11-02 09:27:52 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Apply-eclass_member_speedup_v3.patch.patch) at 2022-10-24 04:12:51 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (figure-1.png) at 2022-09-21 09:43:51 from Yuya Watari <watari.yuya at gmail.com> (Patch: No)
    Attachment (v4-0001-Apply-eclass_member_speedup_v3.patch.patch) at 2022-08-26 00:39:32 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (eclass_member_speedup_v3.patch) at 2022-08-16 08:26:41 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-bugs.patch) at 2022-08-08 11:27:46 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (eclass_member_speedup.patch) at 2022-07-27 21:35:10 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (figure.png) at 2022-07-05 08:57:14 from Yuya Watari <watari.yuya at gmail.com> (Patch: No)
    Attachment (v2-reducing-planning-time-when-tables-have-many-partitions.patch) at 2022-06-22 09:05:43 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)
    Attachment (v1-reducing-planning-time-when-tables-have-many-partitions.patch) at 2022-03-18 10:24:56 from Yuya Watari <watari.yuya at gmail.com> (Patch: Yes)

History

When	Who	What
2023-01-31 16:16:27	vignesh C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-14 00:04:56	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-05 15:53:20	Thom Brown (thom)	Added thom as reviewer
2022-10-24 04:16:48	Yuya Watari (watari)	New status: Needs review
2022-10-12 07:48:06	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 07:48:04	Michael Paquier (michael-kun)	New status: Waiting on Author
2022-08-09 04:21:20	Yuya Watari (watari)	New status: Needs review
2022-08-02 18:02:47	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-21 11:36:20	Andrey Lepikhov (lepikhov)	Added lepikhov as reviewer
2022-07-21 11:35:58	Andrey Lepikhov (lepikhov)	New status: Waiting on Author
2022-06-22 08:42:46	Yuya Watari (watari)	Changed authors to Yuya Watari (watari)
2022-06-22 08:41:43	Yuya Watari (watari)	Attached mail thread CAJ2pMkZNCgoUKSE+_5LthD+KbXKvq6h2hQN8Esxpxd+cxmgomg@mail.gmail.com
2022-06-22 08:41:43	Yuya Watari (watari)	Created patch record