
CREATE TABLE table1 (
 column1 jsonb,
 column3 smallint not null,
 column4 integer  not null,
 column5 integer  not null,
 column6 integer  not null,
 column7 smallint not null
);

ALTER TABLE table1 ADD PRIMARY KEY (column6, column7, column5, column4, column3) WITH (fillfactor='70');
CREATE INDEX table1_index1 ON table1 (column7, column5, column4) WHERE column7 = 1 OR column7 = 1 OR column7 = 1

ALTER TABLE table1 REPLICA IDENTITY FULL;

CREATE TABLE table2
(
 column1     integer primary key,
 column2     jsonb,
 column3     jsonb,
 column5     bigint,
 column6     double precision,
 column7     character varying(32),
 column8     bigint,
 column10    smallint,
 column11    bigint,
 column12    bigint,
 column13    integer,
 column14    bigint
);

CREATE INDEX table2_index1 ON table2 (column1, column14, column12) WITH (fillfactor='90');
CREATE INDEX table2_index2 ON table2 (column11, column14, column12, column8, column1) WITH (fillfactor='50');

ALTER TABLE table2 REPLICA IDENTITY FULL;
