Hi! Thank you for your work on this subject.
I agree with your code but one phrase in commit message was confusing
for me:
"This change is dedicated to more active usage of IndexScan and
parameterised
NestLoop paths in partitioned cases under an Append node, as it already
works
with plain tables."
As I understood this thread is about the optimization that allows
considering Index Scan if we need the limited number of rows and
later the commit message contains it. I didn't understand completely the
sentence above to be honest.
--
Regards,
Alena Rybakina
Postgres Professional