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 2026/03/03 03:35:42 UTC

Re: [PR] [fix](cache) invalidate sorted partition cache after replacing temp partition in cloud mode [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 28781 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a6bfc53bfe06497f42e3b8a000db83f255ad62ec, data reload: false
   
   ------ Round 1 ----------------------------------
   ============================================
   q1	17632	4539	4280	4280
   q2	q3	10650	785	519	519
   q4	4678	356	257	257
   q5	7550	1197	998	998
   q6	171	173	146	146
   q7	776	847	664	664
   q8	9300	1431	1271	1271
   q9	4821	4693	4618	4618
   q10	6797	1865	1646	1646
   q11	488	263	254	254
   q12	713	564	475	475
   q13	17781	4187	3424	3424
   q14	238	236	223	223
   q15	936	797	791	791
   q16	764	722	678	678
   q17	719	860	424	424
   q18	5901	5341	5432	5341
   q19	1141	983	614	614
   q20	511	491	385	385
   q21	4901	1957	1497	1497
   q22	368	326	276	276
   Total cold run time: 96836 ms
   Total hot run time: 28781 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   ============================================
   q1	4661	4612	4687	4612
   q2	q3	1828	2202	1772	1772
   q4	887	1173	765	765
   q5	4058	4404	4402	4402
   q6	187	179	142	142
   q7	1805	1651	1510	1510
   q8	2459	2675	2584	2584
   q9	7460	7085	7329	7085
   q10	2774	2808	2431	2431
   q11	500	428	426	426
   q12	489	572	446	446
   q13	4101	4788	3609	3609
   q14	283	294	290	290
   q15	880	800	781	781
   q16	711	792	714	714
   q17	1203	1565	1291	1291
   q18	7168	6930	6541	6541
   q19	894	881	906	881
   q20	2095	2155	2010	2010
   q21	3995	3480	3381	3381
   q22	466	437	386	386
   Total cold run time: 48904 ms
   Total hot run time: 46059 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