「Pgbench」修訂間的差異
跳至導覽
跳至搜尋
行 31: | 行 31: | ||
0.003 \set aid random(1, 100000 * :scale) | 0.003 \set aid random(1, 100000 * :scale) | ||
1.010 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | 1.010 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | ||
+ | |||
#30个session,读写性能 | #30个session,读写性能 | ||
./pgbench -h 192.168.10.156 -U pgbench -c 30 -T 300 -r pgbench | ./pgbench -h 192.168.10.156 -U pgbench -c 30 -T 300 -r pgbench | ||
行 62: | 行 63: | ||
0.002 \set aid random(1, 100000 * :scale) | 0.002 \set aid random(1, 100000 * :scale) | ||
8.105 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | 8.105 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | ||
+ | |||
#40个session,读写性能 | #40个session,读写性能 | ||
./pgbench -h 192.168.10.156 -U pgbench -c 40 -T 300 -r pgbench | ./pgbench -h 192.168.10.156 -U pgbench -c 40 -T 300 -r pgbench | ||
行 94: | 行 96: | ||
0.002 \set aid random(1, 100000 * :scale) | 0.002 \set aid random(1, 100000 * :scale) | ||
12.168 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | 12.168 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | ||
+ | |||
#60个session,读写性能 | #60个session,读写性能 | ||
./pgbench -h 192.168.10.156 -U pgbench -c 60 -T 300 -r pgbench | ./pgbench -h 192.168.10.156 -U pgbench -c 60 -T 300 -r pgbench | ||
行 126: | 行 129: | ||
0.002 \set aid random(1, 100000 * :scale) | 0.002 \set aid random(1, 100000 * :scale) | ||
19.568 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | 19.568 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | ||
+ | |||
#80个session,读写性能 | #80个session,读写性能 | ||
./pgbench -h 192.168.10.156 -U pgbench -c 80 -T 300 -r pgbench | ./pgbench -h 192.168.10.156 -U pgbench -c 80 -T 300 -r pgbench | ||
行 158: | 行 162: | ||
0.002 \set aid random(1, 100000 * :scale) | 0.002 \set aid random(1, 100000 * :scale) | ||
29.278 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | 29.278 SELECT abalance FROM pgbench_accounts WHERE aid = :aid; | ||
+ | |||
#100个session,读写性能 | #100个session,读写性能 | ||
./pgbench -h 192.168.10.156 -U pgbench -c 100 -T 300 -r pgbench | ./pgbench -h 192.168.10.156 -U pgbench -c 100 -T 300 -r pgbench |
於 2019年10月18日 (五) 11:17 的最新修訂
#1个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 1 -T 300 -r pgbench
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 1
number of threads: 1
duration: 300 s
number of transactions actually processed: 62602
latency average = 4.792 ms
tps = 208.672446 (including connections establishing)
tps = 208.675069 (excluding connections establishing)
#1个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 1 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 1
number of threads: 1
duration: 300 s
number of transactions actually processed: 294834
latency average = 1.018 ms
tps = 982.778611 (including connections establishing)
tps = 982.790906 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.003 \set aid random(1, 100000 * :scale)
1.010 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
#30个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 30 -T 300 -r pgbench
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 30
number of threads: 1
duration: 300 s
number of transactions actually processed: 140570
latency average = 64.564 ms
tps = 464.652135 (including connections establishing)
tps = 464.657686 (excluding connections establishing)
#30个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 30 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 30
number of threads: 1
duration: 300 s
number of transactions actually processed: 1109351
latency average = 8.113 ms
tps = 3697.755242 (including connections establishing)
tps = 3697.798580 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.002 \set aid random(1, 100000 * :scale)
8.105 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
#40个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 40 -T 300 -r pgbench
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 40
number of threads: 1
duration: 300 s
number of transactions actually processed: 140924
latency average = 85.404 ms
tps = 468.363265 (including connections establishing)
tps = 468.368936 (excluding connections establishing)
#40个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 40 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 40
number of threads: 1
duration: 300 s
number of transactions actually processed: 985425
latency average = 12.178 ms
tps = 3284.584917 (including connections establishing)
tps = 3284.623497 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.002 \set aid random(1, 100000 * :scale)
12.168 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
#60个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 60 -T 300 -r pgbench
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 60
number of threads: 1
duration: 300 s
number of transactions actually processed: 159822
latency average = 113.348 ms
tps = 529.341550 (including connections establishing)
tps = 529.347960 (excluding connections establishing)
#60个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 60 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 60
number of threads: 1
duration: 300 s
number of transactions actually processed: 919073
latency average = 19.587 ms
tps = 3063.331202 (including connections establishing)
tps = 3063.367406 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.002 \set aid random(1, 100000 * :scale)
19.568 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
#80个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 80 -T 300 -r pgbench
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 80
number of threads: 1
duration: 300 s
number of transactions actually processed: 153965
latency average = 155.949 ms
tps = 512.986960 (including connections establishing)
tps = 512.993305 (excluding connections establishing)
#80个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 80 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 80
number of threads: 1
duration: 300 s
number of transactions actually processed: 818840
latency average = 29.312 ms
tps = 2729.270760 (including connections establishing)
tps = 2729.304017 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.002 \set aid random(1, 100000 * :scale)
29.278 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
#100个session,读写性能
./pgbench -h 192.168.10.156 -U pgbench -c 100 -T 300 -r pgbench
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 714
query mode: simple
number of clients: 100
number of threads: 1
duration: 300 s
number of transactions actually processed: 175622
latency average = 173.804 ms
tps = 575.360072 (including connections establishing)
tps = 575.366715 (excluding connections establishing)
#100个session,只读性能
./pgbench -h 192.168.10.156 -U pgbench -c 100 -T 300 -r pgbench -S
Password:
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 714
query mode: simple
number of clients: 100
number of threads: 1
duration: 300 s
number of transactions actually processed: 701231
latency average = 42.786 ms
tps = 2337.210651 (including connections establishing)
tps = 2337.237060 (excluding connections establishing)
script statistics:
- statement latencies in milliseconds:
0.002 \set aid random(1, 100000 * :scale)
42.731 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;