Compression17 charts
Compression Throughput vs Parquet
⚡Write Speed (Compression)2.48x
📤Scan Speed (Decompression)16.43x
Inverse geomean of Vortex/Parquet ratios (higher is better)
arade
loading…
bimbo
loading…
cmsprovider
loading…
euro2016
loading…
food
loading…
hashtags
loading…
taxi
loading…
tpc-h l_comment canonical
loading…
tpc-h l_comment chunked
loading…
wide table cols=10000 chunks=1 rows=1000
loading…
wide table cols=10000 chunks=50 rows=1000
loading…
wide table cols=1000 chunks=1 rows=1000
loading…
wide table cols=1000 chunks=50 rows=1000
loading…
wide table cols=100 chunks=1 rows=1000
loading…
wide table cols=100 chunks=50 rows=1000
loading…
wide table cols=10 chunks=1 rows=1000
loading…
wide table cols=10 chunks=50 rows=1000
loading…
Compression Size26 charts
Compression Size Summary
⬇️Min Size Ratio0.56x
📊Mean Size Ratio1.07x
⬆️Max Size Ratio1.38x
Geomean of Vortex/Parquet size ratios (lower is better)
appian
loading…
arade
loading…
bimbo
loading…
clickbench
loading…
cmsprovider
loading…
euro2016
loading…
fineweb
loading…
food
loading…
hashtags
loading…
polarsignals/1000000
loading…
statpopgen/100000
loading…
taxi
loading…
tpcds
loading…
tpch
loading…
tpch/10
loading…
tpch/100
loading…
tpc-h l_comment canonical
loading…
tpc-h l_comment chunked
loading…
wide table cols=10000 chunks=1 rows=1000
loading…
wide table cols=10000 chunks=50 rows=1000
loading…
wide table cols=1000 chunks=1 rows=1000
loading…
wide table cols=1000 chunks=50 rows=1000
loading…
wide table cols=100 chunks=1 rows=1000
loading…
wide table cols=100 chunks=50 rows=1000
loading…
wide table cols=10 chunks=1 rows=1000
loading…
wide table cols=10 chunks=50 rows=1000
loading…
Clickbench43 charts
Performance Summary
#1duckdb:vortex1.21x13.73 s
#2datafusion:vortex1.25x15.10 s
#3datafusion:parquet1.68x21.40 s
#4duckdb:parquet1.69x17.71 s
#5duckdb:duckdb1.70x16.72 s
#6datafusion:vortex-compact1.79x20.56 s
#7duckdb:vortex-compact1.84x18.21 s
#8datafusion:lance11.23x98.48 s
Geomean of query time ratio to fastest (lower is better)
Q0
loading…
Q1
loading…
Q2
loading…
Q3
loading…
Q4
loading…
Q5
loading…
Q6
loading…
Q7
loading…
Q8
loading…
Q9
loading…
Q10
loading…
Q11
loading…
Q12
loading…
Q13
loading…
Q14
loading…
Q15
loading…
Q16
loading…
Q17
loading…
Q18
loading…
Q19
loading…
Q20
loading…
Q21
loading…
Q22
loading…
Q23
loading…
Q24
loading…
Q25
loading…
Q26
loading…
Q27
loading…
Q28
loading…
Q29
loading…
Q30
loading…
Q31
loading…
Q32
loading…
Q33
loading…
Q34
loading…
Q35
loading…
Q36
loading…
Q37
loading…
Q38
loading…
Q39
loading…
Q40
loading…
Q41
loading…
Q42
loading…
TPC-H (NVMe) (SF=1)22 charts
Performance Summary
#1duckdb:duckdb1.16x592.52 ms
#2duckdb:vortex1.40x707.11 ms
#3datafusion:vortex1.43x738.41 ms
#4duckdb:vortex-compact1.66x829.31 ms
#5datafusion:vortex-compact1.69x849.91 ms
#6datafusion:arrow1.96x1.09 s
#7duckdb:parquet3.35x1.78 s
#8datafusion:parquet3.98x1.95 s
#9datafusion:lance4.42x2.47 s
Geomean of query time ratio to fastest (lower is better)
TPC-H (S3) (SF=1)22 charts
Performance Summary
#1datafusion:lance1.26x7.69 s
#2datafusion:vortex-compact1.26x7.26 s
#3datafusion:parquet1.29x7.64 s
#4datafusion:vortex1.32x7.48 s
#5duckdb:vortex-compact2.20x13.13 s
#6duckdb:vortex2.25x13.40 s
#7duckdb:parquet3.19x18.39 s
Geomean of query time ratio to fastest (lower is better)
TPC-H (NVMe) (SF=10)22 charts
Performance Summary
#1duckdb:duckdb1.10x2.80 s
#2duckdb:vortex1.21x3.29 s
#3duckdb:vortex-compact1.61x4.35 s
#4datafusion:vortex1.83x5.72 s
#5duckdb:parquet2.23x5.66 s
#6datafusion:vortex-compact2.24x6.50 s
#7datafusion:parquet3.17x8.12 s
#8datafusion:arrow5.34x16.75 s
#9datafusion:lance10.04x28.82 s
Geomean of query time ratio to fastest (lower is better)
TPC-H (S3) (SF=10)22 charts
Performance Summary
#1datafusion:vortex-compact1.09x16.69 s
#2datafusion:vortex1.13x17.48 s
#3duckdb:vortex-compact1.30x20.26 s
#4duckdb:vortex1.35x21.03 s
#5datafusion:parquet1.47x23.65 s
#6duckdb:parquet2.04x31.35 s
#7datafusion:lance2.33x43.02 s
Geomean of query time ratio to fastest (lower is better)
TPC-H (NVMe) (SF=100)22 charts
Performance Summary
#1duckdb:vortex1.06x30.81 s
#2duckdb:parquet1.42x37.52 s
#3datafusion:vortex1.69x59.71 s
#4datafusion:parquet2.36x69.65 s
Geomean of query time ratio to fastest (lower is better)
TPC-H (S3) (SF=100)22 charts
Performance Summary
#1datafusion:vortex1.07x107.87 s
#2duckdb:vortex1.18x115.05 s
#3duckdb:parquet1.53x145.66 s
#4datafusion:parquet1.62x159.54 s
Geomean of query time ratio to fastest (lower is better)
TPC-DS (NVMe) (SF=1)99 charts
Performance Summary
#1duckdb:duckdb1.12x3.40 s
#2duckdb:parquet1.42x4.03 s
#3duckdb:vortex1.43x3.89 s
#4datafusion:vortex1.84x7.54 s
#5datafusion:parquet1.96x6.48 s
#6duckdb:vortex-compact2.23x6.04 s
#7datafusion:vortex-compact2.40x9.09 s
Geomean of query time ratio to fastest (lower is better)
Q1
loading…
Q2
loading…
Q3
loading…
Q4
loading…
Q5
loading…
Q6
loading…
Q7
loading…
Q8
loading…
Q9
loading…
Q10
loading…
Q11
loading…
Q12
loading…
Q13
loading…
Q14
loading…
Q15
loading…
Q16
loading…
Q17
loading…
Q18
loading…
Q19
loading…
Q20
loading…
Q21
loading…
Q22
loading…
Q23
loading…
Q24
loading…
Q25
loading…
Q26
loading…
Q27
loading…
Q28
loading…
Q29
loading…
Q30
loading…
Q31
loading…
Q32
loading…
Q33
loading…
Q34
loading…
Q35
loading…
Q36
loading…
Q37
loading…
Q38
loading…
Q39
loading…
Q40
loading…
Q41
loading…
Q42
loading…
Q43
loading…
Q44
loading…
Q45
loading…
Q46
loading…
Q47
loading…
Q48
loading…
Q49
loading…
Q50
loading…
Q51
loading…
Q52
loading…
Q53
loading…
Q54
loading…
Q55
loading…
Q56
loading…
Q57
loading…
Q58
loading…
Q59
loading…
Q60
loading…
Q61
loading…
Q62
loading…
Q63
loading…
Q64
loading…
Q65
loading…
Q66
loading…
Q67
loading…
Q68
loading…
Q69
loading…
Q70
loading…
Q71
loading…
Q72
loading…
Q73
loading…
Q74
loading…
Q75
loading…
Q76
loading…
Q77
loading…
Q78
loading…
Q79
loading…
Q80
loading…
Q81
loading…
Q82
loading…
Q83
loading…
Q84
loading…
Q85
loading…
Q86
loading…
Q87
loading…
Q88
loading…
Q89
loading…
Q90
loading…
Q91
loading…
Q92
loading…
Q93
loading…
Q94
loading…
Q95
loading…
Q96
loading…
Q97
loading…
Q98
loading…
Q99
loading…
Random Access9 charts
Random Access Performance
#1lance372.02 us1.00x
#2vortex3.17 ms8.52x
#3parquet8.30 s22305.25x
Random access time | Ratio to fastest (lower is better)
feature-vectors/correlated
loading…
feature-vectors/uniform
loading…
nested-lists/correlated
loading…
nested-lists/uniform
loading…
nested-structs/correlated
loading…
nested-structs/uniform
loading…
taxi
loading…
taxi/correlated
loading…
taxi/uniform
loading…
Statistical and Population Genetics11 charts
Performance Summary
#1duckdb:vortex1.02x8.37 s
#2duckdb:vortex-compact1.69x10.48 s
#3duckdb:parquet2.63x11.44 s
Geomean of query time ratio to fastest (lower is better)
PolarSignals Profiling10 charts
Performance Summary
#1datafusion:vortex1.00x1.10 s
Geomean of query time ratio to fastest (lower is better)