CREATE TABLE test_1 (

    col_a int,
    col_b int,
    col_c text,
    col_d numeric,
    col_e int,
    col_f bigint,
    col_g float,
    col_h double precision

);

INSERT INTO test_1 SELECT i, i+10, md5(i::text), i::numeric / (i+10)::numeric, i-10, i::bigint * 10000, i::float / (i+100), i::float / (i+10000) FROM generate_series(1,100000) s(i);

CREATE TABLE test_2 (

    col_a int,
    col_b int,
    col_c text,
    col_d numeric,
    col_e int,
    col_f int8,
    col_g float,
    col_h double precision

);

INSERT INTO test_2 SELECT i, i+10, md5(i::text), i::numeric / (i+10)::numeric, i-10, i::bigint * 10000, i::float / (i+100), i::float / (i+10000) FROM generate_series(1,100000) s(i);

ANALYZE;