You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2023/12/13 14:12:22 UTC

Re: [PR] [Improvement](decimal) reduce overhead on disable check decimal overflow [doris]

doris-robot commented on PR #28249:
URL: https://github.com/apache/doris/pull/28249#issuecomment-1853992270

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 9d229f2d1743bc8be8e800c4ecc45083492b5df7, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	49824	31868	31804	31804
   q2	371	145	145	145
   q3	1562	1262	1220	1220
   q4	1128	911	876	876
   q5	3197	3227	3171	3171
   q6	263	151	139	139
   q7	1012	500	498	498
   q8	2148	2204	2190	2190
   q9	7007	6909	6894	6894
   q10	3261	3334	3312	3312
   q11	323	202	194	194
   q12	346	211	212	211
   q13	4587	3964	3772	3772
   q14	426	326	318	318
   q15	803	1304	1354	1304
   q16	441	389	395	389
   q17	1027	605	560	560
   q18	7791	7037	6871	6871
   q19	1538	1469	1369	1369
   q20	862	302	292	292
   q21	3056	2566	2611	2566
   q22	341	274	283	274
   Total cold run time: 91314 ms
   Total hot run time: 68369 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	30786	31846	31777	31777
   q2	280	168	169	168
   q3	3617	3614	3603	3603
   q4	2394	2369	2369	2369
   q5	5861	5757	5829	5757
   q6	250	137	127	127
   q7	3045	3398	3377	3377
   q8	3530	3541	3526	3526
   q9	9119	9128	9018	9018
   q10	3984	4056	4065	4056
   q11	780	950	1333	950
   q12	759	604	604	604
   q13	4309	3568	3560	3560
   q14	510	430	440	430
   q15	1137	1319	1340	1319
   q16	504	462	473	462
   q17	1870	1866	1872	1866
   q18	8662	8049	8594	8049
   q19	1718	1779	1774	1774
   q20	2890	2584	2603	2584
   q21	6513	6095	6116	6095
   q22	495	414	410	410
   Total cold run time: 93013 ms
   Total hot run time: 91881 ms
   ```
   </details>
   


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org