example.sql

application/sql

Filename: example.sql

Type: application/sql

Part: 5

Message: Re: 回复: An implementation of multi-key sort

create table t (
c1 int
, 
c2 int
, 
c3 int
, 
c4 int
, 
c5 int
, 
c6 int
, 
c7 int
, 
c8 int
);
insert into t select 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
, 
((10000000 / 1) * random())
from generate_series(1,10000000) s(i);
vacuum analyze;
checkpoint;