create table big as select * from generate_series(1,100000) b;
create table low as select * from generate_series(1,1000) l;
create table lowp as select l+9000 as l from generate_series(1,1000) l;
create table highm as select l+90000 as h from generate_series(1,1000) l;
create table high as select l+100000-1000 as h from generate_series(1,1000) l;
analyze big;
analyze low;
analyze lowp;
analyze high;
analyze highm;
create index bigi on big(b);
create index lowi on low(l);
create index lowpi on lowp(l);
create index highi on high(h);
create index highmi on highm(h);

set enable_nestloop TO 0;
set enable_hashjoin TO 0;

explain select * from big join low on b=l order by b;
explain select * from big join low on b=l order by b desc;

explain select * from big join lowp on b=l order by b;
explain select * from big join lowp on b=l order by b desc;

explain select * from big join highm on b=h order by b;
explain select * from big join highm on b=h order by b desc;

explain select * from big join high on b=h order by b;
explain select * from big join high on b=h order by b desc;