TPCC: Regression in main on 16k wh

[naspirato]

https://datalens.yandex/wf5xdbbl923ok?tab=qrg&state=a060a97a500

Monitoring Link	Branch	Environment	Timestamp (Test Run Start)	Commit SHA	Timestamp (Commit)	Transactions/sec	Throughput (ops/sec)	Throughput (%)	Latency (ms)
origin/main	default	15.10.2024 23:06:29	b390c9db	15.10.2024 18:24:48	16,000	203,701	99.00	256
origin/main	default	15.10.2024 16:35:11	168df93b	15.10.2024 14:15:53	16,000	202,852	98.59	416
origin/main	default	15.10.2024 09:52:55	11f9117b	15.10.2024 07:57:34	16,000	203,371	98.84	288
origin/main	default	14.10.2024 20:35:26	942b770d	14.10.2024 16:53:57	16,000	204,509	99.39	224
origin/main	default	14.10.2024 13:47:30	b4ac18d0	14.10.2024 12:05:43	16,000	204,347	99.31	224
origin/main	default	14.10.2024 06:59:31	ddea4fb3	14.10.2024 05:27:38	16,000	204,426	99.35	224

git log --graph --oneline --pretty=format:'%H - %ad %s' 942b770^..11f9117

• 11f9117 - Tue Oct 15 09:57:34 2024 +0200 PDisk noop scheduler (PDisk noop scheduler #9332)
• 6bd8708 - Tue Oct 15 10:38:08 2024 +0300 Small speedup tpcds generator (Small speedup tpcds generator #10424)
• d14474e - Tue Oct 15 10:37:58 2024 +0300 Fix tpch generator (Fix tpch generator #10423)
• fad0666 - Tue Oct 15 10:26:27 2024 +0300 redefine json_errdetail (redefine json_errdetail #10420)
• 2999825 - Tue Oct 15 08:43:27 2024 +0200 [refactoring] Do not include actorsystem.h into actor.h ([refactoring] Do not include actorsystem.h into actor.h #10394)
• 5d0627c - Tue Oct 15 09:21:30 2024 +0300 YQ-3753 Fix build (YQ-3753 Fix build #10421)
• a0078aa - Tue Oct 15 08:47:40 2024 +0300 YQ-3753 Shared reading: metadatafields (YQ-3753 Shared reading: metadatafields #10370)
• 5a2bffd - Tue Oct 15 07:21:18 2024 +0300 refactoring tpch generator (refactoring tpch generator #10414)
• df7e5a0 - Tue Oct 15 03:04:18 2024 +0300 Add hint for compact Join (Add hint for compact Join #10236)
• 6e67eb5 - Mon Oct 14 22:10:27 2024 +0300 Yq 3724 Move no_pg_wrapper to fq (Yq 3724 Move no_pg_wrapper to fq #10360)
• 942b770 - Mon Oct 14 18:53:57 2024 +0200 ci: add antlr4 to github runner image (ci: add antlr4 to github runner image #10407)

[naspirato]

Без волатильных транзацкий регрессия по tmpc 187 939 -> 178 946 = - 4,5%

Branch	Environment	Timestamp (Test Run Start)	Commit SHA	Timestamp (Commit)	Transactions/sec	Throughput (ops/sec)	Throughput (%)	Latency (ms)
origin/main	default_volatile_off	17.10.2024 10:52:51	11f9117b	15.10.2024 07:57:34	16,000	178,946	86.97	5,500
origin/main	default_volatile_off	17.10.2024 01:40:53	942b770d	14.10.2024 16:53:57	16,000	187,939	91.34	4,250

[naspirato]

Regression starts in commit 11f9117

[va-kuznecov]

possible fix - #10565

[naspirato]

@va-kuznecov
still same results
https://datalens.yandex/wf5xdbbl923ok?tab=qrg&state=ec22e1fb173

origin/main	default_volatile_off	18.10.2024 01:44:10	e8cfb02	17.10.2024 19:39:03	16 000	179 625	87,30	5 500

already after fix

git log --graph --oneline --pretty=format:'%H - %ad %s' d4fa83b84d041d1a01390aa880c9ce9aae93d9b5^..e8cfb021cce59392d89126e52e591781e0013b4f
->> * e8cfb021cce59392d89126e52e591781e0013b4f - Thu Oct 17 22:39:03 2024 +0300 [CBO] No join was chosen bug fix (#10576) <--
* 43a091e932037ca9772b028bf9801b4e3f97077e - Thu Oct 17 21:03:42 2024 +0300 Revert "Removed legacy KV API" (#10552)
* 07c567d0879271ac53c1455e7c1d4c525882d461 - Thu Oct 17 21:03:09 2024 +0300 Revert "Make block combine hashed use stream instead of flow (#9979)" (#10575)
* 99a99889ebad8d7db29ab4db7cb2ce75ac15c0d7 - Thu Oct 17 19:02:01 2024 +0200 Public api to return node id in the describe table call (#10571)
* 81a97e1e811fa596a6018aa74ea1640a8c42abe4 - Thu Oct 17 18:12:40 2024 +0200 [refactoring] Do not include executor_thread.h into actor.h (#10562)
* aadf67f0b404ed91cf4f0f4e4c858928fd3bab31 - Thu Oct 17 18:43:09 2024 +0300 Streamlookup special case nulls in keys (#10508)
->> * d4fa83b84d041d1a01390aa880c9ce9aae93d9b5 - Thu Oct 17 17:34:30 2024 +0200 Set SubmitInFlightBytesMax back to 32KiB (#10565) 
* ```

[va-kuznecov]

revert all noop scheduler related commits - #10600