From: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
---|---|
To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: A minor adjustment to get_cheapest_path_for_pathkeys |
Date: | 2023-09-04 12:35:12 |
Message-ID: | CAJ7c6TM=JV0CwOPf_Db3x0_gDt8T6iqzng_X12Um6MpKJyBk3Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
>> I see the reasoning behind the proposed change, but I'm not convinced
>> that there will be any measurable performance improvements. Firstly,
>> compare_path_costs() is rather cheap. Secondly, require_parallel_safe
>> is `false` in most of the cases. Last but not least, one should prove
>> that this particular place is a bottleneck under given loads. I doubt
>> it is. Most of the time it's a network, disk I/O or locks.
>>
>> So unless the author can provide benchmarks that show measurable
>> benefits of the change I suggest rejecting it.
>
> Hmm, I doubt that there would be any measurable performance gains from
> this minor tweak. I think this tweak is more about being cosmetic. But
> I'm OK if it is deemed unnecessary and thus rejected.
During the triage of the patches submitted for the September CF a
consensus was reached [1] to mark this patch as Rejected.
[1]: https://postgr.es/m/0737f444-59bb-ac1d-2753-873c40da0840%40eisentraut.org
--
Best regards,
Aleksander Alekseev
From | Date | Subject | |
---|---|---|---|
Next Message | Zhijie Hou (Fujitsu) | 2023-09-04 12:38:46 | RE: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases |
Previous Message | Ashutosh Bapat | 2023-09-04 12:34:28 | Re: [17] CREATE SUBSCRIPTION ... SERVER |