run each benchmark type in random access separately#8470
Conversation
Signed-off-by: Mikhail Kot <mikhail@spiraldb.com>
Polar Signals Profiling ResultsLatest Run
Powered by Polar Signals Cloud |
Benchmarks: PolarSignals ProfilingVortex (geomean): 1.036x ➖ How to read Verdict and Engines
datafusion / vortex-file-compressed (1.036x ➖, 0↑ 1↓)
File Size Changes (1 files changed, +0.0% overall, 1↑ 0↓)
Totals:
|
Benchmarks: FineWeb NVMeVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.013x ➖, 0↑ 0↓)
datafusion / vortex-compact (1.005x ➖, 1↑ 1↓)
datafusion / parquet (0.995x ➖, 0↑ 0↓)
duckdb / vortex-file-compressed (1.008x ➖, 0↑ 0↓)
duckdb / vortex-compact (1.003x ➖, 0↑ 0↓)
duckdb / parquet (1.004x ➖, 0↑ 0↓)
File Size Changes (2 files changed, +0.0% overall, 1↑ 1↓)
Totals:
|
Benchmarks: TPC-H SF=1 on NVMEVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.040x ➖, 0↑ 0↓)
datafusion / vortex-compact (1.044x ➖, 0↑ 0↓)
datafusion / parquet (1.032x ➖, 0↑ 2↓)
datafusion / arrow (1.034x ➖, 1↑ 2↓)
duckdb / vortex-file-compressed (1.017x ➖, 0↑ 0↓)
duckdb / vortex-compact (1.030x ➖, 0↑ 0↓)
duckdb / parquet (1.033x ➖, 1↑ 2↓)
duckdb / duckdb (1.026x ➖, 0↑ 0↓)
File Size Changes (9 files changed, +2.2% overall, 7↑ 2↓)
Totals:
|
Merging this PR will not alter performance
|
| Mode | Benchmark | BASE |
HEAD |
Efficiency | |
|---|---|---|---|---|---|
| ❌ | Simulation | chunked_dict_primitive_into_canonical[u32, (1000, 10, 10)] |
120.7 µs | 183 µs | -34.04% |
| ❌ | Simulation | encode_varbin[(1000, 2)] |
176.1 µs | 237.1 µs | -25.74% |
| ❌ | Simulation | take_10k_random |
196.9 µs | 255.6 µs | -22.97% |
| ❌ | Simulation | patched_take_10k_contiguous_patches |
230.6 µs | 290.8 µs | -20.69% |
| ❌ | Simulation | patched_take_10k_random |
242.6 µs | 302.8 µs | -19.89% |
| ❌ | Simulation | chunked_varbinview_canonical_into[(1000, 10)] |
161.8 µs | 198 µs | -18.28% |
| ❌ | Simulation | chunked_varbinview_into_canonical[(1000, 10)] |
177.1 µs | 213.5 µs | -17.06% |
| ❌ | Simulation | bench_many_codes_few_values[1024] |
393.2 µs | 465.6 µs | -15.54% |
| ❌ | Simulation | decompress_rd[f64, (100000, 0.0)] |
845.5 µs | 982.8 µs | -13.97% |
| ❌ | Simulation | varbinview_large |
112.2 µs | 130.4 µs | -13.97% |
| ❌ | Simulation | chunked_varbinview_canonical_into[(100, 100)] |
273.8 µs | 307.9 µs | -11.08% |
| ❌ | Simulation | chunked_varbinview_into_canonical[(100, 100)] |
326.4 µs | 365 µs | -10.58% |
| ⚡ | Simulation | sum_i32_nullable_all_valid |
69.2 µs | 35.4 µs | +95.64% |
| ⚡ | Simulation | null_count_run_end[(10000, 4, 0.01)] |
125.4 µs | 91.5 µs | +37.02% |
| ⚡ | Simulation | encode_varbinview[(1000, 2)] |
189 µs | 157.2 µs | +20.19% |
| ⚡ | Simulation | chunked_varbinview_opt_into_canonical[(1000, 10)] |
229.3 µs | 192.7 µs | +18.96% |
| ⚡ | Simulation | and_bool_nullable |
93.7 µs | 82.7 µs | +13.21% |
| ⚡ | Simulation | baseline_lt[4, 1024] |
78.5 µs | 69.9 µs | +12.23% |
| ⚡ | Simulation | decompress_rd[f64, (100000, 0.01)] |
981.2 µs | 890.4 µs | +10.2% |
| ⚡ | Simulation | decompress_rd[f64, (100000, 0.1)] |
981.2 µs | 890.4 µs | +10.19% |
| ... | ... | ... | ... | ... | ... |
ℹ️ Only the first 20 benchmarks are displayed. Go to the app to view all benchmarks.
Tip
Investigate this regression by commenting @codspeedbot fix this regression on this PR, or directly use the CodSpeed MCP with your agent.
Comparing myrrc/random-access-bench-split-run (6b93cdf) with develop (679e2c5)2
Footnotes
-
11 benchmarks were skipped, so the baseline results were used instead. If they were deleted from the codebase, click here and archive them to remove them from the performance reports. ↩
-
No successful run was found on
develop(0ed06b3) during the generation of this report, so 679e2c5 was used instead as the comparison base. There might be some changes unrelated to this pull request in this report. ↩
Benchmarks: TPC-DS SF=1 on NVMEVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.065x ➖, 0↑ 21↓)
datafusion / vortex-compact (1.046x ➖, 2↑ 12↓)
datafusion / parquet (1.055x ➖, 0↑ 17↓)
duckdb / vortex-file-compressed (1.033x ➖, 1↑ 5↓)
duckdb / vortex-compact (1.044x ➖, 0↑ 8↓)
duckdb / parquet (1.027x ➖, 1↑ 2↓)
duckdb / duckdb (1.033x ➖, 1↑ 3↓)
File Size Changes (15 files changed, +0.4% overall, 11↑ 4↓)
Totals:
|
Benchmarks: Statistical and Population GeneticsVerdict: No clear signal (low confidence) How to read Verdict and Engines
duckdb / vortex-file-compressed (0.997x ➖, 0↑ 0↓)
duckdb / vortex-compact (0.991x ➖, 0↑ 0↓)
duckdb / parquet (0.995x ➖, 0↑ 0↓)
File Size Changes (1 files changed, -0.1% overall, 0↑ 1↓)
Totals:
|
Benchmarks: FineWeb S3Verdict: No clear signal (environment too noisy confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.029x ➖, 0↑ 2↓)
datafusion / vortex-compact (0.919x ➖, 2↑ 0↓)
datafusion / parquet (1.002x ➖, 0↑ 1↓)
duckdb / vortex-file-compressed (1.079x ➖, 0↑ 0↓)
duckdb / vortex-compact (1.040x ➖, 0↑ 1↓)
duckdb / parquet (1.000x ➖, 0↑ 0↓)
|
Benchmarks: TPC-H SF=10 on NVMEVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (0.991x ➖, 0↑ 0↓)
datafusion / vortex-compact (0.992x ➖, 0↑ 0↓)
datafusion / parquet (0.999x ➖, 0↑ 0↓)
datafusion / arrow (0.965x ➖, 1↑ 0↓)
duckdb / vortex-file-compressed (0.978x ➖, 0↑ 0↓)
duckdb / vortex-compact (0.995x ➖, 0↑ 0↓)
duckdb / parquet (1.001x ➖, 1↑ 0↓)
duckdb / duckdb (0.996x ➖, 0↑ 0↓)
File Size Changes (35 files changed, +2.2% overall, 23↑ 12↓)
Totals:
|
Benchmarks: Clickbench on NVMEVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (0.932x ➖, 7↑ 0↓)
datafusion / parquet (0.970x ➖, 2↑ 1↓)
duckdb / vortex-file-compressed (0.966x ➖, 4↑ 1↓)
duckdb / parquet (0.983x ➖, 1↑ 0↓)
duckdb / duckdb (0.947x ➖, 5↑ 0↓)
File Size Changes (108 files changed, +0.4% overall, 99↑ 9↓)
Totals:
|
Benchmarks: TPC-H SF=1 on S3Verdict: No clear signal (environment too noisy confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.029x ➖, 1↑ 5↓)
datafusion / vortex-compact (0.990x ➖, 0↑ 3↓)
datafusion / parquet (0.942x ➖, 2↑ 1↓)
duckdb / vortex-file-compressed (1.044x ➖, 0↑ 0↓)
duckdb / vortex-compact (0.935x ➖, 0↑ 0↓)
duckdb / parquet (1.016x ➖, 0↑ 0↓)
|
Benchmarks: Random AccessVortex (geomean): 0.852x ✅ How to read Verdict and Engines
unknown / unknown (0.928x ➖, 10↑ 1↓)
|
Benchmarks: Appian on NVMEVerdict: No clear signal (low confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.001x ➖, 0↑ 0↓)
datafusion / parquet (0.928x ➖, 1↑ 0↓)
duckdb / vortex-file-compressed (1.029x ➖, 0↑ 1↓)
duckdb / parquet (1.007x ➖, 0↑ 0↓)
duckdb / duckdb (1.021x ➖, 0↑ 1↓)
File Size Changes (6 files changed, +4.9% overall, 3↑ 3↓)
Totals:
|
Benchmarks: TPC-H SF=10 on S3Verdict: No clear signal (environment too noisy confidence) How to read Verdict and Engines
datafusion / vortex-file-compressed (1.026x ➖, 1↑ 1↓)
datafusion / vortex-compact (0.930x ➖, 0↑ 0↓)
datafusion / parquet (0.963x ➖, 1↑ 1↓)
duckdb / vortex-file-compressed (1.018x ➖, 0↑ 0↓)
duckdb / vortex-compact (0.985x ➖, 0↑ 0↓)
duckdb / parquet (0.937x ➖, 0↑ 0↓)
|
Benchmarks: CompressionVortex (geomean): 1.004x ➖ How to read Verdict and Engines
unknown / unknown (1.019x ➖, 1↑ 8↓)
|
If we run vortex solely for feature-vectors in cached mode, runtime in CI-like
box is 400mus. If we run it alongside lance, runtime is 2500mus. Run each
format, cache mode, dataset, and kind separately in CI, and aggreate results
to a file as before