Am Montag, den 06.02.2017, 22:44 +0300 schrieb Alexander Korotkov: > 2. Also could you run each test longer: 3-5 mins, and run them > with > > variety of clients count?
So here are some other results. I've changed max_connections to 300. The bench was prewarmed and run 300s each. I could run more benches, if necessary.
>>>>>> clients 10 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 10 number of threads: 10 duration: 300 s number of transactions actually processed: 47435397 latency average = 0.063 ms tps = 158117.858124 (including connections establishing) tps = 158121.264103 (excluding connections establishing) >>>>>> clients 20 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 20 number of threads: 20 duration: 300 s number of transactions actually processed: 85894461 latency average = 0.070 ms tps = 286314.516993 (including connections establishing) tps = 286325.924487 (excluding connections establishing) >>>>>> clients 80 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 80 number of threads: 80 duration: 300 s number of transactions actually processed: 173185067 latency average = 0.139 ms tps = 577280.609099 (including connections establishing) tps = 577482.251431 (excluding connections establishing) >>>>>> clients 100 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 100 number of threads: 100 duration: 300 s number of transactions actually processed: 182337951 latency average = 0.165 ms tps = 607788.998215 (including connections establishing) tps = 607879.190538 (excluding connections establishing) >>>>>> clients 140 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 140 number of threads: 140 duration: 300 s number of transactions actually processed: 167425515 latency average = 0.251 ms tps = 558080.131402 (including connections establishing) tps = 558230.505974 (excluding connections establishing) >>>>>> clients 200 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 200 number of threads: 200 duration: 300 s number of transactions actually processed: 150990552 latency average = 0.397 ms tps = 503290.086636 (including connections establishing) tps = 503486.345115 (excluding connections establishing)
>>>>>> clients 10 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 10 number of threads: 10 duration: 300 s number of transactions actually processed: 49190440 latency average = 0.061 ms tps = 163967.958649 (including connections establishing) tps = 163970.305002 (excluding connections establishing) >>>>>> clients 20 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 20 number of threads: 20 duration: 300 s number of transactions actually processed: 81753716 latency average = 0.073 ms tps = 272511.936932 (including connections establishing) tps = 272518.387577 (excluding connections establishing) >>>>>> clients 80 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 80 number of threads: 80 duration: 300 s number of transactions actually processed: 173734287 latency average = 0.138 ms tps = 579110.743767 (including connections establishing) tps = 579171.270968 (excluding connections establishing) >>>>>> clients 100 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 100 number of threads: 100 duration: 300 s number of transactions actually processed: 183013962 latency average = 0.164 ms tps = 610042.164629 (including connections establishing) tps = 610124.661236 (excluding connections establishing) >>>>>> clients 140 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 140 number of threads: 140 duration: 300 s number of transactions actually processed: 169105547 latency average = 0.248 ms tps = 563679.957119 (including connections establishing) tps = 563925.230369 (excluding connections establishing) >>>>>> clients 200 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 200 number of threads: 200 duration: 300 s number of transactions actually processed: 152377373 latency average = 0.394 ms tps = 507918.997085 (including connections establishing) tps = 508259.090735 (excluding connections establishing)
>>>>>> clients 10 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 10 number of threads: 10 duration: 300 s number of transactions actually processed: 49556864 latency average = 0.061 ms tps = 165189.402451 (including connections establishing) tps = 165191.717347 (excluding connections establishing) >>>>>> clients 20 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 20 number of threads: 20 duration: 300 s number of transactions actually processed: 82017648 latency average = 0.073 ms tps = 273391.829687 (including connections establishing) tps = 273397.889281 (excluding connections establishing) >>>>>> clients 80 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 80 number of threads: 80 duration: 300 s number of transactions actually processed: 171202536 latency average = 0.140 ms tps = 570671.969756 (including connections establishing) tps = 570730.214380 (excluding connections establishing) >>>>>> clients 100 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 100 number of threads: 100 duration: 300 s number of transactions actually processed: 171975772 latency average = 0.174 ms tps = 573248.585375 (including connections establishing) tps = 573323.981545 (excluding connections establishing) >>>>>> clients 140 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 140 number of threads: 140 duration: 300 s number of transactions actually processed: 153397896 latency average = 0.274 ms tps = 511321.990690 (including connections establishing) tps = 511584.343314 (excluding connections establishing) >>>>>> clients 200 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 200 number of threads: 200 duration: 300 s number of transactions actually processed: 141201630 latency average = 0.425 ms tps = 470665.931532 (including connections establishing) tps = 470873.196919 (excluding connections establishing)
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers