On 5/12/25 20:07, Tom Lane wrote:
Maxim Boguk <maxim.bo...@gmail.com> writes:
Reading the code - probably the lowest hanging fruit is to make
'The current multiplier of 1000 * cpu_operator_cost' configurable in the
future versions.
I'm wondering whether we should try to make the planner not expend
the effort in the first place, but leave partition pruning to the
executor, at least in cases where it can determine that that will be
possible.
Significant planning time is a sorting out lots of scan paths, applying
partition statistics etc. planner-stage partitioning reduces these
efforts drastically.
--
regards, Andrei Lepikhov