gongxun0928 commented on PR #1064: URL: https://github.com/apache/cloudberry/pull/1064#issuecomment-2939220325
Here is the 1TB TPC-DS performance comparison before and after the PR # Hardware and Operating System | CPU (Core Number) | Memory (GB) | Disk (TB) | Operating System | Disk Count | Server Type | |---|---|---|---|---|---| | 96 | 376 | 15 | Oracle Linux 9 x86 | 1 | Physical Server | # Database Cluster Configuration | Number of Nodes | Segment Configuration | Database System Version | |---|---|---| | 4 | 96 segments | PostgreSQL 14.4 (Apache Cloudberry 2.0.0+c4ad1602 build 107528) (HashData Lightning 2.0.0+c4ad1602 build 107528) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7.7.0.2), 64-bit compiled on Apr 21 2025 17:30:17 | # GUC Configuration | Name | Value | Master Only | |---|---|---| | optimizer | on | No | | optimizer_analyze_root_partition | on | Yes | | gp_autostats_mode | none | Yes | | default_statistics_target | 100 | No | | gp_vmem_protect_limit | 15000 | No | | max_statement_mem | 14GB | No | | statement_mem | 1GB | No | | gp_fts_probe_timeout | 600 | No | | gp_fts_probe_interval | 600 | No | | gp_segment_connect_timeout | 1800 | No | | gp_interconnect_queue_depth | 20 | No | | gp_interconnect_snd_queue_depth | 8 | No | | gp_interconnect_min_retries_before_timeout | 100 | No | | autovacuum | off | No | | max_connections | 500 | No | | max_prepared_transactions | 100 | No | | work_mem | 512MB | No | | gp_interconnect_type | tcp | No | | gp_interconnect_tcp_listener_backlog | 2048 | No | # Individual Query Performance Results | Query / Report | main(link libpostgres.so) Query Duration (Seconds) | With PR(link obj files) Query Duration (Seconds) | |---|---|---| | Total Time | 2404 | 2286 | | Data Load | 517 | 510 | | Query 101 | 1 | 1 | | Query 102 | 20 | 17 | | Query 103 | 8 | 7 | | Query 104 | 94 | 85 | | Query 105 | 18 | 16 | | Query 106 | 8 | 9 | | Query 107 | 13 | 12 | | Query 108 | 8 | 8 | | Query 109 | 30 | 28 | | Query 110 | 9 | 9 | | Query 111 | 47 | 43 | | Query 112 | 3 | 3 | | Query 113 | 14 | 14 | | Query 114 | 86 | 75 | | Query 115 | 5 | 4 | | Query 116 | 11 | 10 | | Query 117 | 17 | 17 | | Query 118 | 9 | 8 | | Query 119 | 9 | 9 | | Query 120 | 5 | 4 | | Query 121 | 6 | 7 | | Query 122 | 14 | 13 | | Query 123 | 254 | 246 | | Query 124 | 128 | 121 | | Query 125 | 16 | 15 | | Query 126 | 7 | 7 | | Query 127 | 13 | 12 | | Query 128 | 16 | 15 | | Query 129 | 15 | 15 | | Query 130 | 2 | 2 | | Query 131 | 12 | 11 | | Query 132 | 8 | 7 | | Query 133 | 12 | 11 | | Query 134 | 11 | 10 | | Query 135 | 13 | 12 | | Query 136 | 14 | 13 | | Query 137 | 7 | 6 | | Query 138 | 21 | 19 | | Query 139 | 27 | 24 | | Query 140 | 6 | 5 | | Query 141 | 0 | 0 | | Query 142 | 8 | 7 | | Query 143 | 11 | 11 | | Query 144 | 7 | 7 | | Query 145 | 4 | 3 | | Query 146 | 13 | 12 | | Query 147 | 19 | 18 | | Query 148 | 14 | 13 | | Query 149 | 12 | 12 | | Query 150 | 13 | 11 | | Query 151 | 20 | 19 | | Query 152 | 8 | 7 | | Query 153 | 9 | 9 | | Query 154 | 17 | 16 | | Query 155 | 8 | 7 | | Query 156 | 11 | 12 | | Query 157 | 11 | 10 | | Query 158 | 10 | 9 | | Query 159 | 153 | 156 | | Query 160 | 12 | 11 | | Query 161 | 13 | 11 | | Query 162 | 5 | 5 | | Query 163 | 9 | 8 | | Query 164 | 34 | 32 | | Query 165 | 29 | 28 | | Query 166 | 8 | 8 | | Query 167 | 300 | 290 | | Query 168 | 13 | 12 | | Query 169 | 9 | 8 | | Query 170 | 25 | 24 | | Query 171 | 15 | 13 | | Query 172 | 100 | 98 | | Query 173 | 9 | 9 | | Query 174 | 37 | 36 | | Query 175 | 21 | 27 | | Query 176 | 6 | 5 | | Query 177 | 12 | 12 | | Query 178 | 67 | 64 | | Query 179 | 15 | 14 | | Query 180 | 16 | 16 | | Query 181 | 3 | 3 | | Query 182 | 16 | 14 | | Query 183 | 3 | 2 | | Query 184 | 2 | 3 | | Query 185 | 4 | 5 | | Query 186 | 5 | 5 | | Query 187 | 20 | 18 | | Query 188 | 36 | 33 | | Query 189 | 10 | 9 | | Query 190 | 4 | 4 | | Query 191 | 1 | 1 | | Query 192 | 6 | 5 | | Query 193 | 12 | 12 | | Query 194 | 10 | 10 | | Query 195 | 100 | 93 | | Query 196 | 8 | 7 | | Query 197 | 24 | 23 | | Query 198 | 7 | 7 | | Query 199 | 10 | 9 | -- 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]
