Em seg., 15 de ago. de 2022 às 15:34, Ranier Vilela <ranier...@gmail.com> escreveu:
> Hi, > > I ran this test. > > DROP TABLE IF EXISTS long_json_as_text; > CREATE TABLE long_json_as_text AS > with long as ( > select repeat(description, 11) > from pg_description > ) > select (select json_agg(row_to_json(long))::text as t from long) from > generate_series(1, 100); > VACUUM FREEZE long_json_as_text; > > select 1 from long_json_as_text where t::json is null; > > head: > Time: 161,741ms > > v5: > Time: 270,298 ms > Sorry too fast, 270,298ms with native memchr. v5 Time: 208,689 ms regards, Ranier Vilela
