Re: [PoC] Reducing planning time when tables have many partitions
Yuya Watari <watari.yuya@gmail.com>
From: Yuya Watari <watari.yuya@gmail.com>
To: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Cc: jian he <jian.universality@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
Alena Rybakina <lena.ribackina@yandex.ru>, Andrei Lepikhov <a.lepikhov@postgrespro.ru>,
David Rowley <dgrowleyml@gmail.com>, Thom Brown <thom@linux.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Zhang Mingli <zmlpostgres@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-10-15T03:20:04Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Update wording in optimizer/README for EquivalenceClasses
- d7c04db27aeb 18.0 landed
-
Speedup child EquivalenceMember lookup in planner
- d69d45a5a956 18.0 landed
-
Allow planner to use Merge Append to efficiently implement UNION
- 66c0185a3d14 17.0 cited
-
Remove trailing zero words from Bitmapsets
- a8c09daa8bb1 17.0 cited
-
Make Vars be outer-join-aware.
- 2489d76c4906 16.0 cited
-
Avoid making commutatively-duplicate clauses in EquivalenceClasses.
- a5fc46414deb 16.0 cited
Attachments
- v27-0001-Speed-up-searches-for-child-EquivalenceMembers.patch (application/octet-stream) patch v27-0001
- v27-0002-Introduce-indexes-for-RestrictInfo.patch (application/octet-stream) patch v27-0002
- v27-0003-Move-EquivalenceClass-indexes-to-PlannerInfo.patch (application/octet-stream) patch v27-0003
- v27-0004-Rename-add_eq_member-to-add_parent_eq_member.patch (application/octet-stream) patch v27-0004
- v27-0005-Resolve-conflict-with-commit-66c0185.patch (application/octet-stream) patch v27-0005
Hello, On Tue, Oct 1, 2024 at 11:35 AM Yuya Watari <watari.yuya@gmail.com> wrote: > > I noticed the patches do not apply to the current master. I have > attached the rebased version. There are no changes besides the rebase. The previous patches do not apply to the current master, so I have attached the rebased version. -- Best regards, Yuya Watari