
drop table test;
create table test(x int, a varchar, b varchar, c varchar, d varchar);
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 and x < 200000;
insert into test select i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i, repeat('a',30)||i from
generate_series(1,6000000) as i;
delete from test where x%2!=0 and x < 200000;

