oracleloyall commented on PR #1365:
URL: https://github.com/apache/cloudberry/pull/1365#issuecomment-3316765761

   ```
   Test results for 4 concurrent connections and 96 nodes
   | Query ID | (MTU 1500) Optimized motion execution time | Origin motion 
execution time | Improvement ratio |
   |----------|---------------------------|----------------------|-------------|
   | 101      | 8                         | 8                    | 1           |
   | 102      | 38                        | 39                   | 1.026315789 |
   | 103      | 16                        | 16                   | 1           |
   | 104      | 196                       | 1430                 | 7.295918367 |
   | 105      | 49                        | 49                   | 1           |
   | 106      | 16                        | 16                   | 1           |
   | 107      | 27                        | 27                   | 1           |
   | 108      | 19                        | 21                   | 1.105263158 |
   | 109      | 108                       | 108                  | 1           |
   | 110      | 29                        | 29                   | 1           |
   | 111      | 112                       | 817                  | 7.294642857 |
   | 112      | 5                         | 5                    | 1           |
   | 113      | 29                        | 29                   | 1           |
   | 114      | 298                       | 300                  | 1.006711409 |
   | 115      | 11                        | 10                   | 0.909090909 |
   | 116      | 44                        | 1803                 | 40.97727273 |
   | 117      | 33                        | 33                   | 1           |
   | 118      | 37                        | 27                   | 0.72972973  |
   | 119      | 21                        | 21                   | 1           |
   | 120      | 8                         | 8                    | 1           |
   | 121      | 6                         | 6                    | 1           |
   | 122      | 13                        | 13                   | 1           |
   | 123      | 1442                      | 18600                | 12.89875173 |
   | 124      | 312                       | 7613                 | 24.40064103 |
   | 125      | 33                        | 68                   | 2.060606061 |
   | 126      | 15                        | 19                   | 1.266666667 |
   | 127      | 26                        | 28                   | 1.076923077 |
   | 128      | 59                        | 58                   | 0.983050847 |
   | 129      | 33                        | 32                   | 0.96969697  |
   | 130      | 12                        | 3                    | 0.25        |
   | 131      | 36                        | 37                   | 1.027777778 |
   | 132      | 16                        | 15                   | 0.9375      |
   | 133      | 36                        | 36                   | 1           |
   | 134      | 22                        | 22                   | 1           |
   | 135      | 43                        | 37                   | 0.860465116 |
   | 136      | 31                        | 31                   | 1           |
   | 137      | 6                         | 6                    | 1           |
   | 138      | 68                        | 745                  | 10.95588235 |
   | 139      | 10                        | 10                   | 1           |
   | 140      | 10                        | 11                   | 1.1         |
   | 141      | 1                         | 0                    | 0           |
   | 142      | 16                        | 16                   | 1           |
   | 143      | 22                        | 22                   | 1           |
   | 144      | 27                        | 27                   | 1           |
   | 145      | 7                         | 8                    | 1.142857143 |
   | 146      | 30                        | 29                   | 0.966666667 |
   | 147      | 38                        | 38                   | 1           |
   | 148      | 33                        | 33                   | 1           |
   | 149      | 39                        | 39                   | 1           |
   | 150      | 23                        | 24                   | 1.043478261 |
   | 151      | 36                        | 37                   | 1.027777778 |
   | 152      | 16                        | 16                   | 1           |
   | 153      | 19                        | 19                   | 1           |
   | 154      | 36                        | 31                   | 0.861111111 |
   | 155      | 16                        | 16                   | 1           |
   | 156      | 31                        | 31                   | 1           |
   | 157      | 21                        | 21                   | 1           |
   | 158      | 28                        | 28                   | 1           |
   | 159      | 95                        | 96                   | 1.010526316 |
   | 160      | 39                        | 39                   | 1           |
   | 161      | 42                        | 42                   | 1           |
   | 162      | 10                        | 10                   | 1           |
   | 163      | 19                        | 19                   | 1           |
   | 164      | 57                        | 54                   | 0.947368421 |
   | 165      | 53                        | 53                   | 1           |
   | 166      | 20                        | 20                   | 1           |
   | 167      | 560                       | 3843                 | 6.8625      |
   | 168      | 28                        | 28                   | 1           |
   | 169      | 28                        | 28                   | 1           |
   | 170      | 54                        | 54                   | 1           |
   | 171      | 31                        | 30                   | 0.967741935 |
   | 172      | 281                       | 307                  | 1.09252669  |
   | 173      | 20                        | 21                   | 1.05        |
   | 174      | 79                        | 733                  | 9.278481013 |
   | 175      | 72                        | 66                   | 0.916666667 |
   | 176      | 16                        | 16                   | 1           |
   | 177      | 35                        | 35                   | 1           |
   | 178      | 157                       | 167                  | 1.063694268 |
   | 179      | 28                        | 27                   | 0.964285714 |
   | 180      | 45                        | 44                   | 0.977777778 |
   | 181      | 11                        | 7                    | 0.636363636 |
   | 182      | 9                         | 9                    | 1           |
   | 183      | 5                         | 5                    | 1           |
   | 184      | 14                        | 6                    | 0.428571429 |
   | 185      | 13                        | 13                   | 1           |
   | 186      | 9                         | 10                   | 1.111111111 |
   | 187      | 68                        | 513                  | 7.544117647 |
   | 188      | 131                       | 130                  | 0.992366412 |
   | 189      | 20                        | 20                   | 1           |
   | 190      | 9                         | 9                    | 1           |
   | 191      | 2                         | 3                    | 1.5         |
   | 192      | 8                         | 8                    | 1           |
   | 193      | 23                        | 24                   | 1.043478261 |
   | 194      | 22                        | 561                  | 25.5        |
   | 195      | 189                       | 1155                 | 6.111111111 |
   | 196      | 16                        | 17                   | 1.0625      |
   | 197      | 42                        | 41                   | 0.976190476 |
   | 198      | 16                        | 17                   | 1.0625      |
   | 199      | 19                        | 18                   | 0.947368421 |
   |          | 6167                      | 40919                | 6.635154856 |
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to