drop table test;
create table test(x int, a varchar, b varchar, c varchar, d varchar, e varchar, f varchar, g varchar, h varchar, first_name text);
create index idx1 on test(a) where x%2=0;
create index idx2 on test(b) where x%2=0;
create index idx3 on test(c) where x%2=0;
create index idx4 on test(d) where x%2 = 0;
create index idx5 on test(e) where x%2=0;
create index idx6 on test(f) where x%2=0;
create index idx7 on test(g) where x%2=0;
create index idx8 on test(h) where x%2 = 0;
create index idx9 on test(a) where x%2=0;
create index idx10 on test(b) where x%2=0;
create index idx11 on test(c) where x%2=0;
create index idx12 on test(d) where x%2 = 0;
create index idx13 on test(e) where x%2=0;
create index idx14 on test(f) where x%2=0;
create index idx15 on test using BRIN (x) where x%2=0;
create index idx16 on test USING hash (h) where x%2 = 0;
insert into test select i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i from
generate_series(1,1000000) as i;
checkpoint;
delete from test where x%2!=0 and x < 200000;
delete from test;
checkpoint;

