You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
INSERT INTO gin_check_text_array select array_agg(md5(round(random()*300)::text)::text) from generate_series(1, 100000) as i group by i % 10000;
53
+
INSERT INTO gin_check_text_array select array_agg(sha256(round(random()*300)::text::bytea)::text) from generate_series(1, 100000) as i group by i % 10000;
54
54
-- posting leaves
55
-
INSERT INTO gin_check_text_array select array_agg(md5(round(random()*300 + 300)::text)::text) from generate_series(1, 10000) as i group by i % 100;
55
+
INSERT INTO gin_check_text_array select array_agg(sha256(round(random()*300 + 300)::text::bytea)::text) from generate_series(1, 10000) as i group by i % 100;
56
56
CREATE INDEX gin_check_text_array_idx on "gin_check_text_array" USING GIN("Column1");
INSERT INTO gin_check_text_array select array_agg(md5(round(random()*300)::text)::text) from generate_series(1, 100000) as i group by i % 10000;
33
+
INSERT INTO gin_check_text_array select array_agg(sha256(round(random()*300)::text::bytea)::text) from generate_series(1, 100000) as i group by i % 10000;
34
34
-- posting leaves
35
-
INSERT INTO gin_check_text_array select array_agg(md5(round(random()*300+300)::text)::text) from generate_series(1, 10000) as i group by i % 100;
35
+
INSERT INTO gin_check_text_array select array_agg(sha256(round(random()*300+300)::text::bytea)::text) from generate_series(1, 10000) as i group by i % 100;
36
36
CREATEINDEXgin_check_text_array_idxon"gin_check_text_array" USING GIN("Column1");
0 commit comments