From: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Richard Guo <guofenglinux(at)gmail(dot)com> |
Subject: | Re: A minor adjustment to get_cheapest_path_for_pathkeys |
Date: | 2023-07-11 12:16:38 |
Message-ID: | CAJ7c6TMj1scTXKe0Qy8y3Xo2Ej7q3t0kqgE=5gGVz4bLeYdcNg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
> The check for parallel_safe should be even cheaper than cost comparison
> so I think it's better to do that first. The attached patch does this
> and also updates the comment to mention the requirement about being
> parallel-safe.
The patch was marked as "Needs review" so I decided to take a look.
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.
--
Best regards,
Aleksander Alekseev
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2023-07-11 12:29:07 | Re: pg_decode_message vs skip_empty_xacts and xact_wrote_changes |
Previous Message | Jeevan Chalke | 2023-07-11 12:00:55 | Re: unrecognized node type while displaying a Path due to dangling pointer |