Hi, Andy, your words make sense, but to me it seems that in add_paths_to_append_rel we have no other options than tuple_fraction from root, and rows (if any) in paths we take into account, please correct me if I am wrong.
Thank you! Also, on top of that I have an idea of pruning unnecessary partitions in generate_orderedappend_paths() when we have a valid LIMIT value. I'm currently checking if it is working correctly in multiple cases, so 'll send it after we deal with this issue. -- Regards, Nikita Malakhov Postgres Professional The Russian Postgres Company https://postgrespro.ru/