1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
########################################################################
bulk_insert.lua + PostgreSQL tests
########################################################################
$ . $SBTEST_INCDIR/pgsql_common.sh
$ . $SBTEST_INCDIR/script_bulk_insert_common.sh
Creating table 'sbtest1'...
Creating table 'sbtest2'...
Table "public.sbtest1"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+--------------------+---------+--------------+-------------
id | integer | not null | plain | |
k | integer | not null default 0 | plain | |
Indexes:
CREATE UNIQUE INDEX sbtest1_pkey ON sbtest1 USING btree (id)
Table "public.sbtest2"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+--------------------+---------+--------------+-------------
id | integer | not null | plain | |
k | integer | not null default 0 | plain | |
Indexes:
CREATE UNIQUE INDEX sbtest2_pkey ON sbtest2 USING btree (id)
Did not find any relation named "sbtest3".
sysbench * (glob)
Running the test with following options:
Number of threads: 2
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 0
write: [12] (re)
other: 0
total: [12] (re)
transactions: 100 (* per sec.) (glob)
queries: [12] \(.* per sec.\) (re)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: *s (glob)
total number of events: 100
Latency (ms):
min: *.* (glob)
avg: *.* (glob)
max: *.* (glob)
95th percentile: *.* (glob)
sum: *.* (glob)
Threads fairness:
events (avg/stddev):* (glob)
execution time (avg/stddev):* (glob)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Did not find any relation named "sbtest1".
Did not find any relation named "sbtest2".
Did not find any relation named "sbtest3".
|
