Query Performance Degradation Due to Partition Scan Order – PostgreSQL v17.6

failed: regress/insert, regress/insert_conflict, regress/create_misc, regress/create_view, regress/triggers, regress/select, regress/inherit, regress/updatable_views, regress/subselect, regress/union, regress/join, regress/aggregates, regress/portals, regress/update, regress/rowsecurity, regress/tablesample, regress/identity, regress/generated_stored, regress/misc, regress/collate.icu.utf8, regress/generated_virtual, regress/psql, regress/select_parallel, regress/foreign_key, regress/cluster, regress/window, regress/equivclass, regress/rangefuncs, regress/truncate, regress/alter_table, regress/rowtypes, regress/returning, regress/with, regress/partition_join, regress/partition_prune, regress/partition_aggregate, regress/memoize, regress/predicate, file_fdw/file_fdw, isolation/detach-partition-concurrently-1, isolation/detach-partition-concurrently-2, isolation/detach-partition-concurrently-3, isolation/detach-partition-concurrently-4, isolation/fk-snapshot, isolation/eval-plan-qual, isolation/inherit-temp, isolation/merge-update, pg_upgrade/002_pg_upgrade