jsonagg_speedtest.sql

drop table if exists data_table;
create table data_table (f1 text);
insert into data_table select x::text from generate_series(1,10000) x;
vacuum analyze data_table;

\timing on

do $$
begin
  for i in 1..10000 loop
    perform json_agg(f1) from data_table;
  end loop;
end$$;

do $$
begin
  for i in 1..10000 loop
    perform jsonb_agg(f1) from data_table;
  end loop;
end$$;