| From: | Chengpeng Yan <chengpeng_yan(at)Outlook(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(at)vondra(dot)me> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, John Naylor <johncnaylorls(at)gmail(dot)com> |
| Subject: | Re: Add a greedy join search algorithm to handle large join problems |
| Date: | 2025-12-02 13:04:11 |
| Message-ID: | 313ACE5A-CBF1-43B3-9181-10D3E8ADF424@Outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
> On Dec 2, 2025, at 18:56, Tomas Vondra <tomas(at)vondra(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zsolt Parragi | 2025-12-02 13:05:49 | Custom oauth validator options |
| Previous Message | Jakub Wartak | 2025-12-02 12:26:33 | Re: Adding basic NUMA awareness |