Skip to content

Commit d7d665c

Browse files
dongjoon-hyundongjoon-hyun
committed
Recover
1 parent b4bbff4 commit d7d665c

File tree

6 files changed

+2369
-0
lines changed

6 files changed

+2369
-0
lines changed

‎sql/core/benchmarks/CompressionSchemeBenchmark-results.txt‎

Lines changed: 137 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,137 @@
1+
================================================================================================
2+
Compression Scheme Benchmark
3+
================================================================================================
4+
5+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
6+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
7+
BOOLEAN Encode: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
8+
------------------------------------------------------------------------------------------------
9+
PassThrough(1.000) 4 / 4 17998.9 0.1 1.0X
10+
RunLengthEncoding(2.501) 680 / 680 98.7 10.1 0.0X
11+
BooleanBitSet(0.125) 365 / 365 183.9 5.4 0.0X
12+
13+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
14+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
15+
BOOLEAN Decode: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
16+
------------------------------------------------------------------------------------------------
17+
PassThrough 144 / 144 466.5 2.1 1.0X
18+
RunLengthEncoding 679 / 679 98.9 10.1 0.2X
19+
BooleanBitSet 1425 / 1431 47.1 21.2 0.1X
20+
21+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
22+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
23+
SHORT Encode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
24+
------------------------------------------------------------------------------------------------
25+
PassThrough(1.000) 7 / 7 10115.0 0.1 1.0X
26+
RunLengthEncoding(1.494) 1671 / 1672 40.2 24.9 0.0X
27+
28+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
29+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
30+
SHORT Decode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
31+
------------------------------------------------------------------------------------------------
32+
PassThrough 1128 / 1128 59.5 16.8 1.0X
33+
RunLengthEncoding 1630 / 1633 41.2 24.3 0.7X
34+
35+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
36+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
37+
SHORT Encode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
38+
------------------------------------------------------------------------------------------------
39+
PassThrough(1.000) 7 / 7 10164.2 0.1 1.0X
40+
RunLengthEncoding(1.989) 1562 / 1563 43.0 23.3 0.0X
41+
42+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
43+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
44+
SHORT Decode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
45+
------------------------------------------------------------------------------------------------
46+
PassThrough 1127 / 1127 59.6 16.8 1.0X
47+
RunLengthEncoding 1629 / 1631 41.2 24.3 0.7X
48+
49+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
50+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
51+
INT Encode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
52+
------------------------------------------------------------------------------------------------
53+
PassThrough(1.000) 22 / 23 2983.2 0.3 1.0X
54+
RunLengthEncoding(1.003) 2426 / 2427 27.7 36.1 0.0X
55+
DictionaryEncoding(0.500) 958 / 958 70.1 14.3 0.0X
56+
IntDelta(0.250) 286 / 286 235.0 4.3 0.1X
57+
58+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
59+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
60+
INT Decode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
61+
------------------------------------------------------------------------------------------------
62+
PassThrough 1268 / 1269 52.9 18.9 1.0X
63+
RunLengthEncoding 1906 / 1911 35.2 28.4 0.7X
64+
DictionaryEncoding 981 / 982 68.4 14.6 1.3X
65+
IntDelta 812 / 817 82.6 12.1 1.6X
66+
67+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
68+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
69+
INT Encode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
70+
------------------------------------------------------------------------------------------------
71+
PassThrough(1.000) 23 / 23 2926.9 0.3 1.0X
72+
RunLengthEncoding(1.326) 2614 / 2614 25.7 38.9 0.0X
73+
DictionaryEncoding(0.501) 1024 / 1024 65.5 15.3 0.0X
74+
IntDelta(0.250) 286 / 286 234.7 4.3 0.1X
75+
76+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
77+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
78+
INT Decode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
79+
------------------------------------------------------------------------------------------------
80+
PassThrough 1433 / 1433 46.8 21.4 1.0X
81+
RunLengthEncoding 1923 / 1926 34.9 28.6 0.7X
82+
DictionaryEncoding 1285 / 1285 52.2 19.2 1.1X
83+
IntDelta 1129 / 1137 59.4 16.8 1.3X
84+
85+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
86+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
87+
LONG Encode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
88+
------------------------------------------------------------------------------------------------
89+
PassThrough(1.000) 45 / 45 1495.6 0.7 1.0X
90+
RunLengthEncoding(0.738) 2662 / 2663 25.2 39.7 0.0X
91+
DictionaryEncoding(0.250) 1269 / 1269 52.9 18.9 0.0X
92+
LongDelta(0.125) 450 / 450 149.1 6.7 0.1X
93+
94+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
95+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
96+
LONG Decode (Lower Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
97+
------------------------------------------------------------------------------------------------
98+
PassThrough 1483 / 1483 45.3 22.1 1.0X
99+
RunLengthEncoding 1875 / 1875 35.8 27.9 0.8X
100+
DictionaryEncoding 1213 / 1214 55.3 18.1 1.2X
101+
LongDelta 816 / 817 82.2 12.2 1.8X
102+
103+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
104+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
105+
LONG Encode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
106+
------------------------------------------------------------------------------------------------
107+
PassThrough(1.000) 45 / 45 1489.3 0.7 1.0X
108+
RunLengthEncoding(1.003) 2906 / 2906 23.1 43.3 0.0X
109+
DictionaryEncoding(0.251) 1610 / 1610 41.7 24.0 0.0X
110+
LongDelta(0.125) 451 / 451 148.7 6.7 0.1X
111+
112+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
113+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
114+
LONG Decode (Higher Skew): Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
115+
------------------------------------------------------------------------------------------------
116+
PassThrough 1485 / 1485 45.2 22.1 1.0X
117+
RunLengthEncoding 1889 / 1890 35.5 28.2 0.8X
118+
DictionaryEncoding 1215 / 1216 55.2 18.1 1.2X
119+
LongDelta 1107 / 1110 60.6 16.5 1.3X
120+
121+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
122+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
123+
STRING Encode: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
124+
------------------------------------------------------------------------------------------------
125+
PassThrough(1.000) 67 / 68 994.5 1.0 1.0X
126+
RunLengthEncoding(0.894) 5877 / 5882 11.4 87.6 0.0X
127+
DictionaryEncoding(0.167) 3597 / 3602 18.7 53.6 0.0X
128+
129+
OpenJDK 64-Bit Server VM 1.8.0_181-b13 on Linux 3.10.0-862.3.2.el7.x86_64
130+
Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
131+
STRING Decode: Best/Avg Time(ms) Rate(M/s) Per Row(ns) Relative
132+
------------------------------------------------------------------------------------------------
133+
PassThrough 3243 / 3244 20.7 48.3 1.0X
134+
RunLengthEncoding 3598 / 3601 18.7 53.6 0.9X
135+
DictionaryEncoding 3182 / 3182 21.1 47.4 1.0X
136+
137+

0 commit comments

Comments
 (0)