Re: A minor adjustment to get_cheapest_path_for_pathkeys

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

In response to

Responses

Browse pgsql-hackers by date

  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