[go: up one dir, main page]
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Merge distinct fix #3905

Merged
merged 5 commits into from
Jul 25, 2024
Merged

Merge distinct fix #3905

merged 5 commits into from
Jul 25, 2024

Conversation

acquamarin
Copy link
Collaborator

No description provided.

@acquamarin acquamarin changed the title Distinct mark test Merge distinct fix Jul 23, 2024
@github-actions GitHub Actions
Copy link

Benchmark Result

Master commit hash: 77386aeacc4554df1d9337c3decc5610f335ab93
Branch commit hash: 8e64e795ff8ee5a1eb04955461f4b2b878951cb6

Query Group Query Name Mean Time - Commit (ms) Mean Time - Master (ms) Diff
aggregation q24 673.14 674.37 -1.23 (-0.18%)
aggregation q28 12706.00 12975.10 -269.10 (-2.07%)
filter q14 154.08 152.07 2.00 (1.32%)
filter q15 154.69 154.02 0.68 (0.44%)
filter q16 328.18 324.05 4.13 (1.27%)
filter q17 486.70 477.06 9.64 (2.02%)
filter q18 1949.53 1970.04 -20.51 (-1.04%)
fixed_size_expr_evaluator q07 702.16 591.53 110.63 (18.70%)
fixed_size_expr_evaluator q08 812.08 817.19 -5.10 (-0.62%)
fixed_size_expr_evaluator q09 865.42 813.60 51.81 (6.37%)
fixed_size_expr_evaluator q10 281.28 269.48 11.80 (4.38%)
fixed_size_expr_evaluator q11 275.34 262.51 12.82 (4.89%)
fixed_size_expr_evaluator q12 296.05 264.03 32.02 (12.13%)
fixed_size_expr_evaluator q13 1496.90 1494.34 2.56 (0.17%)
fixed_size_seq_scan q23 146.58 147.35 -0.76 (-0.52%)
join q31 47.53 48.05 -0.52 (-1.09%)
ldbc_snb_ic q35 3731.00 3897.67 -166.67 (-4.28%)
ldbc_snb_ic q36 139.04 133.04 5.99 (4.50%)
ldbc_snb_is q32 10.68 10.31 0.37 (3.63%)
ldbc_snb_is q33 95.76 100.08 -4.32 (-4.31%)
ldbc_snb_is q34 92.47 90.38 2.08 (2.31%)
multi-rel multi-rel-large-scan 4111.92 3332.42 779.50 (23.39%)
multi-rel multi-rel-lookup 49.01 45.38 3.63 (8.00%)
multi-rel multi-rel-small-scan 65.88 58.92 6.96 (11.81%)
order_by q25 156.21 152.86 3.35 (2.19%)
order_by q26 469.89 465.34 4.55 (0.98%)
order_by q27 1417.89 1448.85 -30.96 (-2.14%)
scan_after_filter q01 200.02 201.91 -1.89 (-0.94%)
scan_after_filter q02 189.48 189.84 -0.35 (-0.19%)
shortest_path_ldbc100 q39 170.01 165.57 4.44 (2.68%)
var_size_expr_evaluator q03 2078.23 2109.70 -31.48 (-1.49%)
var_size_expr_evaluator q04 2250.74 2272.30 -21.56 (-0.95%)
var_size_expr_evaluator q05 2562.27 2633.78 -71.51 (-2.72%)
var_size_expr_evaluator q06 1398.31 1397.91 0.40 (0.03%)
var_size_seq_scan q19 1512.96 1487.63 25.33 (1.70%)
var_size_seq_scan q20 3164.61 3154.73 9.88 (0.31%)
var_size_seq_scan q21 2435.75 2431.98 3.77 (0.16%)
var_size_seq_scan q22 135.16 134.50 0.66 (0.49%)

@github-actions GitHub Actions
Copy link

Benchmark Result

Master commit hash: 43c708bff69af92d4c061cbfd1a53dbb2efccd65
Branch commit hash: 6c02f71dd384d6c476e5b266f9185a8e3c4e4e23

Query Group Query Name Mean Time - Commit (ms) Mean Time - Master (ms) Diff
aggregation q24 667.68 672.19 -4.51 (-0.67%)
aggregation q28 11395.83 11035.86 359.97 (3.26%)
filter q14 149.98 149.98 0.01 (0.01%)
filter q15 153.05 154.55 -1.50 (-0.97%)
filter q16 331.46 325.23 6.23 (1.92%)
filter q17 475.01 475.49 -0.48 (-0.10%)
filter q18 1955.17 1949.23 5.94 (0.30%)
fixed_size_expr_evaluator q07 601.35 629.61 -28.26 (-4.49%)
fixed_size_expr_evaluator q08 815.08 868.64 -53.56 (-6.17%)
fixed_size_expr_evaluator q09 818.05 871.18 -53.12 (-6.10%)
fixed_size_expr_evaluator q10 265.54 284.11 -18.57 (-6.54%)
fixed_size_expr_evaluator q11 258.14 278.01 -19.87 (-7.15%)
fixed_size_expr_evaluator q12 263.87 272.50 -8.62 (-3.16%)
fixed_size_expr_evaluator q13 1497.89 1561.58 -63.68 (-4.08%)
fixed_size_seq_scan q23 140.99 144.69 -3.70 (-2.56%)
join q31 47.73 49.02 -1.29 (-2.63%)
ldbc_snb_ic q35 3763.52 3751.01 12.51 (0.33%)
ldbc_snb_ic q36 121.37 112.31 9.06 (8.06%)
ldbc_snb_is q32 10.34 10.45 -0.11 (-1.04%)
ldbc_snb_is q33 98.32 90.62 7.70 (8.50%)
ldbc_snb_is q34 97.05 87.88 9.17 (10.43%)
multi-rel multi-rel-large-scan 3656.46 3516.32 140.14 (3.99%)
multi-rel multi-rel-lookup 42.20 44.97 -2.77 (-6.15%)
multi-rel multi-rel-small-scan 63.30 65.00 -1.70 (-2.61%)
order_by q25 147.77 157.13 -9.36 (-5.96%)
order_by q26 470.74 481.72 -10.98 (-2.28%)
order_by q27 1419.92 1448.68 -28.76 (-1.99%)
scan_after_filter q01 199.35 204.56 -5.21 (-2.54%)
scan_after_filter q02 186.44 196.02 -9.58 (-4.89%)
shortest_path_ldbc100 q39 150.72 149.36 1.36 (0.91%)
var_size_expr_evaluator q03 2047.76 2233.33 -185.57 (-8.31%)
var_size_expr_evaluator q04 2258.35 2308.59 -50.24 (-2.18%)
var_size_expr_evaluator q05 2693.63 2992.50 -298.88 (-9.99%)
var_size_expr_evaluator q06 1341.05 1519.93 -178.88 (-11.77%)
var_size_seq_scan q19 1473.37 1506.67 -33.29 (-2.21%)
var_size_seq_scan q20 3128.09 3168.78 -40.69 (-1.28%)
var_size_seq_scan q21 2384.58 2421.11 -36.52 (-1.51%)
var_size_seq_scan q22 130.84 134.26 -3.42 (-2.55%)

@github-actions GitHub Actions
Copy link

Benchmark Result

Master commit hash: 8e80d3e4934a5ee304fff88ee13810ce59395cd3
Branch commit hash: 3cbe89f60384bcfba999b371314b7cb5994c845c

Query Group Query Name Mean Time - Commit (ms) Mean Time - Master (ms) Diff
aggregation q24 677.53 689.16 -11.63 (-1.69%)
aggregation q28 11822.09 11433.05 389.04 (3.40%)
filter q14 143.32 156.34 -13.02 (-8.33%)
filter q15 150.60 151.88 -1.27 (-0.84%)
filter q16 319.09 322.66 -3.57 (-1.11%)
filter q17 467.42 475.03 -7.61 (-1.60%)
filter q18 1921.39 1950.55 -29.16 (-1.50%)
fixed_size_expr_evaluator q07 586.34 589.99 -3.65 (-0.62%)
fixed_size_expr_evaluator q08 808.44 815.70 -7.26 (-0.89%)
fixed_size_expr_evaluator q09 808.80 812.37 -3.57 (-0.44%)
fixed_size_expr_evaluator q10 265.41 268.54 -3.13 (-1.17%)
fixed_size_expr_evaluator q11 253.89 262.39 -8.49 (-3.24%)
fixed_size_expr_evaluator q12 253.75 261.37 -7.62 (-2.92%)
fixed_size_expr_evaluator q13 1492.38 1495.56 -3.18 (-0.21%)
fixed_size_seq_scan q23 138.45 149.02 -10.57 (-7.09%)
join q31 45.17 50.28 -5.11 (-10.17%)
ldbc_snb_ic q35 3734.24 3729.56 4.69 (0.13%)
ldbc_snb_ic q36 123.19 129.77 -6.59 (-5.07%)
ldbc_snb_is q32 9.98 10.18 -0.19 (-1.89%)
ldbc_snb_is q33 92.19 97.28 -5.09 (-5.23%)
ldbc_snb_is q34 100.82 95.39 5.43 (5.69%)
multi-rel multi-rel-large-scan 3238.30 3175.36 62.95 (1.98%)
multi-rel multi-rel-lookup 42.44 44.99 -2.55 (-5.67%)
multi-rel multi-rel-small-scan 70.80 71.62 -0.82 (-1.14%)
order_by q25 151.10 155.96 -4.86 (-3.11%)
order_by q26 469.07 466.51 2.56 (0.55%)
order_by q27 1419.69 1446.85 -27.17 (-1.88%)
scan_after_filter q01 189.10 200.23 -11.13 (-5.56%)
scan_after_filter q02 178.48 186.58 -8.10 (-4.34%)
shortest_path_ldbc100 q39 96.41 154.72 -58.31 (-37.69%)
var_size_expr_evaluator q03 2088.11 2103.64 -15.54 (-0.74%)
var_size_expr_evaluator q04 2269.71 2279.55 -9.84 (-0.43%)
var_size_expr_evaluator q05 2635.75 2643.44 -7.69 (-0.29%)
var_size_expr_evaluator q06 1347.85 1396.89 -49.04 (-3.51%)
var_size_seq_scan q19 1481.09 1486.03 -4.95 (-0.33%)
var_size_seq_scan q20 3176.26 3122.87 53.39 (1.71%)
var_size_seq_scan q21 2411.25 2432.89 -21.64 (-0.89%)
var_size_seq_scan q22 131.66 133.64 -1.98 (-1.48%)

@acquamarin acquamarin merged commit 6a77ee9 into master Jul 25, 2024
22 checks passed
@acquamarin acquamarin deleted the distinct-mark-test branch July 25, 2024 09:22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@ray6080 ray6080 ray6080 approved these changes

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

None yet
3 participants
@acquamarin @ray6080 @andyfengHKU