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