Userwhite opened a new issue, #11391:
URL: https://github.com/apache/doris/issues/11391

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Description
   
   I had done a test 
   - 测试集 TPCDS 1T
   - 表 catalog_sales
   
默认为数据量为456G,100bucket,3副本;为了模拟线上多版本的情况,关闭Compaction,执行j几十次下面的insert语句,使tablet的版本数在几十左右。
    insert into catalog_sales (cs_item_sk) values(1);
   - SQL
   ```sql
   select
     *
   from
     tpcds1000.catalog_sales
   where
     cs_item_sk in (1, 2, 3, 4, 5, 6)
     and cs_ship_hdemo_sk = 2618
     and (
       cs_sold_date_sk between 2452641
       and 2452650
     )
     and cs_order_number in (159350362, 159392377, 159609391);
   ```
   -result
   12% CPU in RowBlock Create 24% CPU in RowBlock free
   
![weCehKUjYQ](https://user-images.githubusercontent.com/49226823/182092934-f6ab4323-dca8-42c1-8f8b-e7150cc8dfe4.jpg)
   
   
   
   ### Solution
   
   Because `RowBlockV2` is a temporary data block, We can reuse on single 
thread.
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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-unsubscr...@doris.apache.org.apache.org

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


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

Reply via email to