-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Parallel view processing no longer working #29621
Copy link
Copy link
Closed
Labels
bug-unreleasedBug that affects unreleased or experimental codeBug that affects unreleased or experimental codeperformance
Description
Describe what's wrong
In master, parallel_view_processing doesn't have any effect and the MV are executed sequentially.
Does it reproduce on recent release?
Only master.
Taken from parallel_mv.xml perf test:
create table main_table (number UInt64) engine = MergeTree order by tuple();
create materialized view mv_1 engine = MergeTree order by tuple() as
select number, toString(number) from main_table where number % 13 != 0;
create materialized view mv_2 engine = MergeTree order by tuple() as
select number, toString(number) from main_table where number % 13 != 1;
create materialized view mv_3 engine = MergeTree order by tuple() as
select number, toString(number) from main_table where number % 13 != 3;
create materialized view mv_4 engine = MergeTree order by tuple() as
select number, toString(number) from main_table where number % 13 != 4;21.9.4:
- No parallel: Elapsed: 1.333 sec
- With parallel view processing: 0.588 sec
21.10.2.8264:
- No parallel: 1.372 sec
- Parallel: 0.582
21.11.1.8263 from master:
- No parallel: 1.415 sec
- With parallel: 1.423 sec
Additional context
Checking the stats of CI it points to #28582 as the culptrit.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bug-unreleasedBug that affects unreleased or experimental codeBug that affects unreleased or experimental codeperformance