Re: Add a greedy join search algorithm to handle large join problems
Chengpeng Yan <chengpeng_yan@outlook.com>
From: Chengpeng Yan <chengpeng_yan@Outlook.com>
To: Tomas Vondra <tomas@vondra.me>
Cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>, John Naylor <johncnaylorls@gmail.com>
Date: 2025-12-02T13:04:11Z
Lists: pgsql-hackers
Hi, > On Dec 2, 2025, at 18:56, Tomas Vondra <tomas@vondra.me> wrote: > > I think a much broader evaluation will be needed, comparing not just the > planning time, but also the quality of the final plan. Which for the > starjoin tests does not really matter, as the plans are all equal in > this regard. Many thanks for your feedback. You are absolutely right — plan quality is also very important. In my initial email I only showed the improvements in planning time, but did not provide results regarding plan quality. I will run tests on more complex join scenarios, evaluating both planning time and plan quality. Thanks again! -- Best regards, Chengpeng Yan