假设待排序数组为a，数组元素是长度为K的字符串， 多键排序 41 多键排序 42 ● Group Aggregation ● Merge Join ● Distinct Aggregation ● Sorted Motion 排序在Greenplum中的应用 43 ● Greenplum的聚集节点使用两种聚集方式：哈希聚集和分组聚集。 ● 分组聚集应用了排序的思想，如果数据基于分组键有序，那么聚集可以拆解为 ● Motion的Receiver需要接收多个Sender的数据，虽然每个Sender的数据保证 有序，但Receiver端也需要保证数据全局有序。 Sorted Motion 1 4 7 8 2 3 6 9 1 4 2 3 Sender1 Sender2 Receiver1 47 ● 首先读取每个Sender的第一个元素，之后在Receiver端进行归并排序 Sorted Motion

gp_max_packet_size 1920 gp_max_parallel_cursors 1920 gp_max_plan_size 1921 gp_max_slices 1921 gp_motion_cost_per_row 1921 VMware Greenplum 6 Documentation VMware by Broadcom 113 gp_print_create_gang_time on the segments. Server 370114, 345498 Resolves an issue where passing through parameters by a motion caused the database to panic. The fix prevents external parameters from being passed through. 366165 where pg_dump locked partition tables that were outside the backup set. 32920, 15719 Resolves a motion deadlock that could occur with outer plans and subplans when using UDP interconnect by first prefetching

gp_max_packet_size 1879 gp_max_parallel_cursors 1879 gp_max_plan_size 1879 gp_max_slices 1880 gp_motion_cost_per_row 1880 gp_print_create_gang_time 1880 gp_recursive_cte 1880 gp_reject_percent_threshold where pg_dump locked partition tables that were outside the backup set. 32920, 15719 Resolves a motion deadlock that could occur with outer plans and subplans when using UDP interconnect by first prefetching optimizing a query with multi-stage aggregates for DQA, it generated an incorrect plan that included no motion between the intermediate and final aggregate. 6392 Resolves an issue where GPORCA could not distinguish

gp_max_local_distributed_cache 1590 gp_max_packet_size 1591 gp_max_plan_size 1591 gp_max_slices 1591 gp_motion_cost_per_row 1592 gp_recursive_cte 1592 gp_reject_percent_threshold 1592 gp_reraise_signal 1593 allowing the join inner child to match the distribution of the outer child via a redistribution motion. Server 31888 : Resolved an issue where Greenplum was returning different results when running variables on the query executor. 12161 : Resolved an issue with dispatch conditions and redundant motion node that was generating an assert failure in execMotionUnsortedReceiver. 12648 : Resolved an issue

gp_max_local_distributed_cache 1601 gp_max_packet_size 1601 gp_max_plan_size 1601 gp_max_slices 1602 gp_motion_cost_per_row 1602 gp_recursive_cte 1602 gp_reject_percent_threshold 1603 gp_reraise_signal 1603 Inc. 159 31734 : Greenplum was generating the error ERROR: interconnect error: A HTAB entry for motion node 77 already exists after creating the extension for the ltree module. This issue has been resolved issue where Greenplum Database returned wrong results for a query because it chose an incorrect motion type during plan tree iteration. 12482 : Reinstates the Greenplum Database-specific --wrapper and

gp_max_packet_size 1885 gp_max_parallel_cursors 1885 gp_max_plan_size 1886 gp_max_slices 1886 gp_motion_cost_per_row 1886 gp_print_create_gang_time 1886 gp_recursive_cte 1887 gp_reject_percent_threshold silently errored out when a subplan contained a SharedScan and the subplan’s parent Plan included motion, by fixing cross-slice interaction detection for subplans. VMware Greenplum 6 Documentation VMware type, which allows users to switch from the wildcard default to a unicast IP address to support motion communication. (Resolved by PR- 13344.) 32220 Moves incrementing txns_using_rel to follow ERROR

gp_max_packet_size 1824 gp_max_parallel_cursors 1824 gp_max_plan_size 1825 gp_max_slices 1825 gp_motion_cost_per_row 1825 gp_print_create_gang_time 1825 gp_recursive_cte 1826 gp_reject_percent_threshold silently errored out when a subplan contained a SharedScan and the subplan’s parent Plan included motion, by fixing cross-slice interaction detection for subplans. 11948 Resolved a crash that could occur type, which allows users to switch from the wildcard default to a unicast IP address to support motion communication. (Resolved by PR- 13344.) 32220 Moves incrementing txns_using_rel to follow ERROR

gp_max_local_distributed_cache 1816 gp_max_packet_size 1817 gp_max_plan_size 1817 gp_max_slices 1817 gp_motion_cost_per_row 1817 gp_recursive_cte 1818 gp_reject_percent_threshold 1818 gp_reraise_signal 1818 silently errored out when a subplan contained a SharedScan and the subplan's parent Plan included motion, by fixing cross-slice interaction detection for subplans. 11948 Resolved a crash that could occur type, which allows users to switch from the wildcard default to a unicast IP address to support motion communication. (Resolved by PR-13344.) 32220 : Moves incrementing txns_using_rel to follow ERROR

gp_max_local_distributed_cache 1604 gp_max_packet_size 1604 gp_max_plan_size 1604 gp_max_slices 1604 gp_motion_cost_per_row 1605 gp_recursive_cte 1605 gp_reject_percent_threshold 1605 gp_reraise_signal 1605 type, which allows users to switch from the wildcard default to a unicast IP address to support motion communication. (Resolved by PR- 13344.) 32220 Moves incrementing txns_using_rel to follow ERROR shared memory. 31734 Greenplum was generating the error ERROR: interconnect error: A HTAB entry for motion node 77 already exists after creating the extension for the ltree module. This issue has been resolved

gp_max_local_distributed_cache 1613 gp_max_packet_size 1613 gp_max_plan_size 1613 gp_max_slices 1614 gp_motion_cost_per_row 1614 gp_recursive_cte 1614 gp_reject_percent_threshold 1615 gp_reraise_signal 1615 Inc. 156 31734 : Greenplum was generating the error ERROR: interconnect error: A HTAB entry for motion node 77 already exists after creating the extension for the ltree module. This issue has been resolved issue where Greenplum Database returned wrong results for a query because it chose an incorrect motion type during plan tree iteration. 12482 : Reinstates the Greenplum Database-specific --wrapper and