cyclic.sql

application/sql

Download

create table cyclic (a double precision, b text) with (fillfactor=25);

with x as (select 100000 * (mod(i,(10000000/100))::double precision / (10000000/100)) AS x from generate_series(1,10000000) s(i))
insert into cyclic select x, sha256(x::text::bytea) from x;

vacuum freeze cyclic;

create index on cyclic (a);