bug18588_script.sql

create table tt (employer_id int, payload int);
insert into tt select 5516123,1 from generate_series(1,6213979);
insert into tt select 2180,1 from generate_series(1,2871578);
insert into tt select 3529,1 from generate_series(1,2007333);
insert into tt select 9498112,1 from generate_series(1,1952964);
insert into tt select 5120112,1 from generate_series(1,1475554);
insert into tt select 39305,1 from generate_series(1,1428762);
insert into tt select 1740,1 from generate_series(1,1386494);
insert into tt select 78638,1 from generate_series(1,1318288);
insert into tt select 1947314,1 from generate_series(1,1256758);
insert into tt select 1689259,1 from generate_series(1,1221705);
insert into tt select 49357,1 from generate_series(1,1182208);
insert into tt select 9498120,1 from generate_series(1,1061869);
insert into tt select 3036416,1 from generate_series(1,1044110);
insert into tt select 80,1 from generate_series(1,953178);
insert into tt select 1942330,1 from generate_series(1,952285);
insert into tt select 4181,1 from generate_series(1,921238);
insert into tt select 4934,1 from generate_series(1,903208);
insert into tt select 7172,1 from generate_series(1,825062);
insert into tt select 87021,1 from generate_series(1,805812);
insert into tt select 3776,1 from generate_series(1,773594);
create index on tt(employer_id);

set min_parallel_index_scan_size to '8kB';
set min_parallel_table_scan_size to '8kB';
set parallel_tuple_cost to 0;
set parallel_setup_cost to 0;

explain analyze  select * from tt where employer_id=3776;