setup.sql

application/octet-stream

Filename: setup.sql
Type: application/octet-stream
Part: 2
Message: Re: effective_io_concurrency
truncate pgbench_accounts ;
insert into pgbench_accounts select gen , ((gen-1)/100000)::integer+1,(random()*400000000)::integer,'' from generate_series(1,400000000) as gen;
create index on pgbench_accounts (abalance);