JSONB Testing Results

	A	B	C	D	E	F
1	Test	Item	Detail	9.4 HEAD	All-Lengths	Length-and-Offset-4
2						(newer snapshot)
3	Table Sizes (MB)
4		jsonic	JSON text	393	393	393
5		jsonbish	JSONB	1147	525	541
6		jsonbish2	JSONB EXTERNAL	1221	1200	1206
7		errlog2	simple small json	45	44	44
8		processed_b	large complex jsonb	2991	2511	2510
9
10
11	Extraction Queries (ms)
12		jsonic	Q2	11700	11800	12000
13		jsonbish	Q1	4000	6750	5100
14			Q2	3150	4700	5100
15		jsonbish2	Q1	3250	3350	2400
16			Q2	2700	2650	2700
17
18		errlog2	Q3	110	115	110
19
20		processed_b	Q4	18800	19300	19850
21			Q5	20000	20800	21300
22			Q6	19300	19900	20400
23			Q7	19420	20200	20700
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100