Am Samstag, den 11.02.2017, 00:28 +0100 schrieb Tomas Vondra: > Comparing averages of tps, measured on 5 runs (each 5 minutes long), > the > difference between master and patched master is usually within 2%, > which > is pretty much within noise. > > I'm attaching spreadsheets with summary of the results, so that we > have > it in the archives. As usual, the scripts and much more detailed > results > are available here:
I've done some benchmarking of this patch against the E850/ppc64el Ubuntu LPAR we currently have access to and got the attached results. pg_prewarm as recommended by Alexander was used, the tests run 300s secs, scale 1000, each with a testrun before. The SELECT-only pgbench was run twice each, the write tests only once. Looks like the influence of this patch isn't that big, at least on this machine. We're going to reassign the resources to an AIX LPAR soon, which doesn't give me enough time to test with Tomas' test scripts again.
>>>>>> 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: 39931683 latency average = 0.075 ms tps = 133105.478637 (including connections establishing) tps = 133109.428803 (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: 78852558 latency average = 0.076 ms tps = 262841.340316 (including connections establishing) tps = 262855.469408 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 118612968 latency average = 0.101 ms tps = 395375.595262 (including connections establishing) tps = 395432.166071 (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: 170171627 latency average = 0.141 ms tps = 567235.428660 (including connections establishing) tps = 567322.181229 (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: 168267642 latency average = 0.178 ms tps = 560888.338862 (including connections establishing) tps = 561076.995776 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 146675068 latency average = 0.327 ms tps = 488911.857866 (including connections establishing) tps = 489155.251547 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 139558941 latency average = 0.516 ms tps = 465184.240782 (including connections establishing) tps = 466046.696168 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 137419242 latency average = 0.611 ms tps = 458052.555736 (including connections establishing) tps = 459795.543770 (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: 40994263 latency average = 0.073 ms tps = 136647.383534 (including connections establishing) tps = 136649.850380 (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: 71023846 latency average = 0.084 ms tps = 236745.708077 (including connections establishing) tps = 236752.743230 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 120060357 latency average = 0.100 ms tps = 400200.095159 (including connections establishing) tps = 400238.563079 (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: 170353955 latency average = 0.141 ms tps = 567843.510912 (including connections establishing) tps = 567913.555324 (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: 169034944 latency average = 0.177 ms tps = 563445.359606 (including connections establishing) tps = 563570.002605 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 148999446 latency average = 0.322 ms tps = 496658.855942 (including connections establishing) tps = 496881.446812 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 140925134 latency average = 0.511 ms tps = 469741.966734 (including connections establishing) tps = 470315.112372 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 138396584 latency average = 0.607 ms tps = 461311.366272 (including connections establishing) tps = 463616.087068 (excluding connections establishing)
>>>>>> clients 10 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 10 number of threads: 10 duration: 300 s number of transactions actually processed: 2376419 latency average = 1.262 ms tps = 7921.371808 (including connections establishing) tps = 7921.599824 (excluding connections establishing) >>>>>> clients 20 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 20 number of threads: 20 duration: 300 s number of transactions actually processed: 3780657 latency average = 1.587 ms tps = 12602.156420 (including connections establishing) tps = 12603.071942 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 6510537 latency average = 1.843 ms tps = 21701.669930 (including connections establishing) tps = 21704.812043 (excluding connections establishing) >>>>>> clients 80 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 80 number of threads: 80 duration: 300 s number of transactions actually processed: 9090812 latency average = 2.640 ms tps = 30302.301679 (including connections establishing) tps = 30308.205764 (excluding connections establishing) >>>>>> clients 100 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 100 number of threads: 100 duration: 300 s number of transactions actually processed: 9472741 latency average = 3.167 ms tps = 31574.679938 (including connections establishing) tps = 31579.444172 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 9502487 latency average = 5.051 ms tps = 31674.382349 (including connections establishing) tps = 31684.734690 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 7450455 latency average = 9.664 ms tps = 24833.638729 (including connections establishing) tps = 24866.521521 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 7343432 latency average = 11.439 ms tps = 24477.045555 (including connections establishing) tps = 24523.738599 (excluding connections establishing)
>>>>>> clients 10 <<<<< >>>>>> clients 10 <<<<< >>>>>> 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: 42570775 latency average = 0.070 ms tps = 141902.402572 (including connections establishing) tps = 141905.765836 (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: 69598432 latency average = 0.086 ms tps = 231994.360354 (including connections establishing) tps = 232002.040845 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 116205237 latency average = 0.103 ms tps = 387349.752493 (including connections establishing) tps = 387366.529481 (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: 142393812 latency average = 0.169 ms tps = 474643.805983 (including connections establishing) tps = 474704.059451 (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: 125610112 latency average = 0.239 ms tps = 418697.479634 (including connections establishing) tps = 418937.082310 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 114689712 latency average = 0.419 ms tps = 382294.115170 (including connections establishing) tps = 382395.473453 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 109239029 latency average = 0.659 ms tps = 364123.541809 (including connections establishing) tps = 364752.037236 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 107034818 latency average = 0.785 ms tps = 356775.751968 (including connections establishing) tps = 359363.706718 (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: 45627582 latency average = 0.066 ms tps = 152091.770667 (including connections establishing) tps = 152096.366710 (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: 66172223 latency average = 0.091 ms tps = 220573.717021 (including connections establishing) tps = 220586.814190 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 113634167 latency average = 0.106 ms tps = 378779.664593 (including connections establishing) tps = 378893.034797 (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: 172374274 latency average = 0.139 ms tps = 574577.756142 (including connections establishing) tps = 574844.952169 (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: 167731389 latency average = 0.179 ms tps = 559100.559440 (including connections establishing) tps = 559336.298386 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 146283835 latency average = 0.328 ms tps = 487606.202533 (including connections establishing) tps = 488246.917550 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 138362898 latency average = 0.520 ms tps = 461202.582779 (including connections establishing) tps = 461572.236905 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: select only> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 135880075 latency average = 0.618 ms tps = 452926.221920 (including connections establishing) tps = 455713.547955 (excluding connections establishing)
>>>>>> clients 10 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 10 number of threads: 10 duration: 300 s number of transactions actually processed: 2449170 latency average = 1.225 ms tps = 8163.869128 (including connections establishing) tps = 8164.067544 (excluding connections establishing) >>>>>> clients 20 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 20 number of threads: 20 duration: 300 s number of transactions actually processed: 4238474 latency average = 1.416 ms tps = 14128.175200 (including connections establishing) tps = 14129.267287 (excluding connections establishing) >>>>>> clients 40 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 40 number of threads: 40 duration: 300 s number of transactions actually processed: 6651686 latency average = 1.804 ms tps = 22172.136448 (including connections establishing) tps = 22174.550274 (excluding connections establishing) >>>>>> clients 80 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 80 number of threads: 80 duration: 300 s number of transactions actually processed: 9214139 latency average = 2.605 ms tps = 30713.483239 (including connections establishing) tps = 30719.046662 (excluding connections establishing) >>>>>> clients 100 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 100 number of threads: 100 duration: 300 s number of transactions actually processed: 9667045 latency average = 3.103 ms tps = 32223.080081 (including connections establishing) tps = 32229.692645 (excluding connections establishing) >>>>>> clients 160 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 160 number of threads: 160 duration: 300 s number of transactions actually processed: 10019567 latency average = 4.791 ms tps = 33397.557559 (including connections establishing) tps = 33409.512729 (excluding connections establishing) >>>>>> clients 240 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 240 number of threads: 240 duration: 300 s number of transactions actually processed: 7987615 latency average = 9.014 ms tps = 26624.593507 (including connections establishing) tps = 26636.808641 (excluding connections establishing) >>>>>> clients 280 <<<<< transaction type: <builtin: TPC-B (sort of)> scaling factor: 1000 query mode: prepared number of clients: 280 number of threads: 280 duration: 300 s number of transactions actually processed: 7015519 latency average = 11.974 ms tps = 23384.304471 (including connections establishing) tps = 23415.194033 (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
