Content-Length: 427941 | pFad | http://github.com/postgrespro/postgres/commit/33a263a7a14ae103cd85ca937490fc11ea3e6879

B1 TMP: direct TOAST TIDS · postgrespro/postgres@33a263a · GitHub
Skip to content

Commit 33a263a

Browse files
author
Nikita Glukhov
committed
TMP: direct TOAST TIDS
1 parent f1f4ab3 commit 33a263a

File tree

5 files changed

+901
-89
lines changed

5 files changed

+901
-89
lines changed

contrib/jsonb_toaster/expected/jsonb_toaster.out

Lines changed: 105 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -17,4 +17,109 @@ SELECT i, (
1717
FROM generate_series(1,10) j
1818
)
1919
FROM generate_series(1, 10) i;
20+
SELECT id, key, pg_column_size(value::text) FROM test_jsonb_toaster, jsonb_each(jb);
21+
id | key | pg_column_size
22+
----+-------+----------------
23+
1 | key1 | 12
24+
1 | key2 | 16
25+
1 | key3 | 24
26+
1 | key4 | 40
27+
1 | key5 | 72
28+
1 | key6 | 136
29+
1 | key7 | 264
30+
1 | key8 | 520
31+
1 | key9 | 1032
32+
1 | key10 | 2056
33+
2 | key1 | 16
34+
2 | key2 | 24
35+
2 | key3 | 40
36+
2 | key4 | 72
37+
2 | key5 | 136
38+
2 | key6 | 264
39+
2 | key7 | 520
40+
2 | key8 | 1032
41+
2 | key9 | 2056
42+
2 | key10 | 4104
43+
3 | key1 | 24
44+
3 | key2 | 40
45+
3 | key3 | 72
46+
3 | key4 | 136
47+
3 | key5 | 264
48+
3 | key6 | 520
49+
3 | key7 | 1032
50+
3 | key8 | 2056
51+
3 | key9 | 4104
52+
3 | key10 | 8200
53+
4 | key1 | 40
54+
4 | key2 | 72
55+
4 | key3 | 136
56+
4 | key4 | 264
57+
4 | key5 | 520
58+
4 | key6 | 1032
59+
4 | key7 | 2056
60+
4 | key8 | 4104
61+
4 | key9 | 8200
62+
4 | key10 | 16392
63+
5 | key1 | 72
64+
5 | key2 | 136
65+
5 | key3 | 264
66+
5 | key4 | 520
67+
5 | key5 | 1032
68+
5 | key6 | 2056
69+
5 | key7 | 4104
70+
5 | key8 | 8200
71+
5 | key9 | 16392
72+
5 | key10 | 32776
73+
6 | key1 | 136
74+
6 | key2 | 264
75+
6 | key3 | 520
76+
6 | key4 | 1032
77+
6 | key5 | 2056
78+
6 | key6 | 4104
79+
6 | key7 | 8200
80+
6 | key8 | 16392
81+
6 | key9 | 32776
82+
6 | key10 | 65544
83+
7 | key1 | 264
84+
7 | key2 | 520
85+
7 | key3 | 1032
86+
7 | key4 | 2056
87+
7 | key5 | 4104
88+
7 | key6 | 8200
89+
7 | key7 | 16392
90+
7 | key8 | 32776
91+
7 | key9 | 65544
92+
7 | key10 | 131080
93+
8 | key1 | 520
94+
8 | key2 | 1032
95+
8 | key3 | 2056
96+
8 | key4 | 4104
97+
8 | key5 | 8200
98+
8 | key6 | 16392
99+
8 | key7 | 32776
100+
8 | key8 | 65544
101+
8 | key9 | 131080
102+
8 | key10 | 262152
103+
9 | key1 | 1032
104+
9 | key2 | 2056
105+
9 | key3 | 4104
106+
9 | key4 | 8200
107+
9 | key5 | 16392
108+
9 | key6 | 32776
109+
9 | key7 | 65544
110+
9 | key8 | 131080
111+
9 | key9 | 262152
112+
9 | key10 | 524296
113+
10 | key1 | 2056
114+
10 | key2 | 4104
115+
10 | key3 | 8200
116+
10 | key4 | 16392
117+
10 | key5 | 32776
118+
10 | key6 | 65544
119+
10 | key7 | 131080
120+
10 | key8 | 262152
121+
10 | key9 | 524296
122+
10 | key10 | 1048584
123+
(100 rows)
124+
20125
DROP TABLE test_jsonb_toaster;

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/33a263a7a14ae103cd85ca937490fc11ea3e6879

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy