custom_types_and_array.sql

CREATE SCHEMA test;
\timing on

SELECT FORMAT('CREATE TYPE test.film_summary%s AS (
                 film_id INT, 
                 title VARCHAR, 
                 release_year SMALLINT
               );', g.id)
  FROM generate_series(1, 60000) AS g(id)
\gexec

SELECT FORMAT('SELECT (1, %1$L, 2024)::test.film_summary%2$s;', 'Test', g.id)
  FROM generate_series(1, 60000) AS g(id)
\gexec


BEGIN;

SELECT FORMAT('create temporary table ttt%s (
  _C_1RRef bytea,
  _C_2RRef bytea,
  _C_3RRef bytea,
  _C_4 varchar(150),
  _C_5 numeric(9,0),
  _C_6RRef bytea,
  _C_7RRef bytea,
  _C_8RRef bytea,
  _C_9RRef bytea,
  _C_10 boolean,
  _C_11 numeric(5,0),
  _C_12 numeric(10,0),
  _C_13 varchar(430),
  _C_14 numeric(5,0),
  _C_15RRef bytea,
  _C_16RRef bytea,
  _C_17RRef bytea,
  _C_18RRef bytea,
  _C_19_TYPE bytea,
  _C_19_S varchar(150),
  _C_19_RTRef bytea,
  _C_19_RRRef bytea,
  _C_20 varchar,
  _C_21 varchar,
  _C_22 numeric(9,0),
  _TTC_1 bytea,
  _TTC_2 numeric(9,0),
  SDBL_IDENTITY int
);', g.id) AS cmd
  FROM generate_series(1, 2400) AS g(id)
\gexec

ROLLBACK;