9
create table message_section_map (
16
open(MSG,">message.tmp") || die;
17
open(MAP,">message_section_map.tmp") || die;
20
#foreach my $i ( 1..1778 ) {
21
#foreach my $i ( 1..3443 ) {
22
#foreach my $i ( 1..5000 ) {
23
#foreach my $i ( 1..29362 ) {
24
#foreach my $i ( 1..33331 ) {
25
#foreach my $i ( 1..83268 ) {
26
foreach my $i ( 1..200000 ) {
29
$sect[0] = int( (rand()**4)*100 );
32
@sect = grep { $hash{$_}++; $hash{$_} <= 1 } map { int( (rand()**4)*100) } 0..( int(rand()*5) );
34
if ( $#sect < 0 || rand() < 0.1 ) {
35
print MSG "$i\t\\N\n";
37
print MSG "$i\t{".join(',',@sect)."}\n";
38
map { print MAP "$i\t$_\n" } @sect;
45
copytable('message_section_map');
49
CREATE unique index message_key on message ( mid );
50
--CREATE unique index message_section_map_key1 on message_section_map ( mid, sid );
51
CREATE unique index message_section_map_key2 on message_section_map ( sid, mid );
52
CREATE INDEX message_rdtree_idx on message using gist ( sections gist__int_ops );
55
select count(*) from message;
56
select count(*) from message_section_map;
63
unlink 'message.tmp', 'message_section_map.tmp';
68
print "COPY $t from stdin;\n";
69
open( FFF, "$t.tmp") || die;
70
while(<FFF>) { print; }