do $$
declare
  t0 timestamp with time zone;
begin

---
  raise info '%', (select version());
  drop table if exists test;
  create unlogged table test ( f1 timestamp, f2 boolean, f3 float );

  t0 := clock_timestamp();
  for i in 1..10000000 loop
    insert into test(f1, f2, f3) values (clock_timestamp(), i%2=0, i);
  end loop;
  raise info 'time % unlogged table+for, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));

  drop table if exists test;
  create unlogged table test ( f1 timestamp, f2 boolean, f3 float );

  t0 := clock_timestamp();
  insert into test(f1, f2, f3) select clock_timestamp(), i%2=0, i from generate_series(1, 10000000) i;
  raise info 'time % unlogged table+generate_series, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));

  copy (select * from test) to '/tmp/test.dmp';
  
  drop table if exists test;
  create unlogged table test ( f1 timestamp, f2 boolean, f3 float );

  t0 := clock_timestamp();
  copy test from '/tmp/test.dmp';
  raise info 'time % unlogged table+copy, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));

---
  drop table if exists test;
  create table test ( f1 timestamp, f2 boolean, f3 float );

  t0 := clock_timestamp();
  for i in 1..10000000 loop
      insert into test(f1, f2, f3) values (clock_timestamp(), i%2=0, i);
  end loop;
  raise info 'time % table+for, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));


  drop table if exists test;
  create table test ( f1 timestamp, f2 boolean, f3 float );

  t0 := clock_timestamp();
  insert into test(f1, f2, f3) select clock_timestamp(), i%2=0, i from generate_series(1, 10000000) i;
  raise info 'time % table+generate_series, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));

  copy (select * from test) to '/tmp/test.dmp';
  
  drop table if exists test;
  create table test ( f1 timestamp, f2 boolean, f3 float );
  t0 := clock_timestamp();
  copy test from '/tmp/test.dmp';
  raise info 'time % table+copy, size %', clock_timestamp()-t0, (select pg_size_pretty(pg_total_relation_size(cast('test' as regclass))));
  
end $$;