Created
September 26, 2017 05:25
-
-
Save tomdcc/3f3398fd44f920287f67a4cc1de501ac to your computer and use it in GitHub Desktop.
PGJDBC master vs tuple class benchmarks for ProcessResultSet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 0.00% complete, ETA 00:07:00 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 50.859 us/op | |
# Warmup Iteration 2: 42.516 us/op | |
# Warmup Iteration 3: 42.246 us/op | |
# Warmup Iteration 4: 41.526 us/op | |
# Warmup Iteration 5: 41.963 us/op | |
# Warmup Iteration 6: 41.581 us/op | |
# Warmup Iteration 7: 41.713 us/op | |
# Warmup Iteration 8: 41.806 us/op | |
# Warmup Iteration 9: 42.190 us/op | |
# Warmup Iteration 10: 42.839 us/op | |
Iteration 1: 42.232 us/op | |
Iteration 2: 41.928 us/op | |
Iteration 3: 41.532 us/op | |
Iteration 4: 41.545 us/op | |
Iteration 5: 41.965 us/op | |
Iteration 6: 41.553 us/op | |
Iteration 7: 41.621 us/op | |
Iteration 8: 41.692 us/op | |
Iteration 9: 41.501 us/op | |
Iteration 10: 41.549 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
41.712 ±(99.9%) 0.372 us/op [Average] | |
(min, avg, max) = (41.501, 41.712, 42.232), stdev = 0.246 | |
CI (99.9%): [41.339, 42.084] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 4.76% complete, ETA 00:06:46 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 50.347 us/op | |
# Warmup Iteration 2: 43.229 us/op | |
# Warmup Iteration 3: 43.161 us/op | |
# Warmup Iteration 4: 42.957 us/op | |
# Warmup Iteration 5: 43.002 us/op | |
# Warmup Iteration 6: 43.285 us/op | |
# Warmup Iteration 7: 43.087 us/op | |
# Warmup Iteration 8: 42.868 us/op | |
# Warmup Iteration 9: 43.936 us/op | |
# Warmup Iteration 10: 45.219 us/op | |
Iteration 1: 43.293 us/op | |
Iteration 2: 46.038 us/op | |
Iteration 3: 42.614 us/op | |
Iteration 4: 42.846 us/op | |
Iteration 5: 42.518 us/op | |
Iteration 6: 42.716 us/op | |
Iteration 7: 42.711 us/op | |
Iteration 8: 42.773 us/op | |
Iteration 9: 43.070 us/op | |
Iteration 10: 42.998 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
43.158 ±(99.9%) 1.569 us/op [Average] | |
(min, avg, max) = (42.518, 43.158, 46.038), stdev = 1.038 | |
CI (99.9%): [41.589, 44.727] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 9.52% complete, ETA 00:06:27 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 53.823 us/op | |
# Warmup Iteration 2: 46.005 us/op | |
# Warmup Iteration 3: 45.770 us/op | |
# Warmup Iteration 4: 46.331 us/op | |
# Warmup Iteration 5: 45.687 us/op | |
# Warmup Iteration 6: 45.644 us/op | |
# Warmup Iteration 7: 45.312 us/op | |
# Warmup Iteration 8: 45.403 us/op | |
# Warmup Iteration 9: 45.503 us/op | |
# Warmup Iteration 10: 45.443 us/op | |
Iteration 1: 45.645 us/op | |
Iteration 2: 45.512 us/op | |
Iteration 3: 45.559 us/op | |
Iteration 4: 45.558 us/op | |
Iteration 5: 45.368 us/op | |
Iteration 6: 45.561 us/op | |
Iteration 7: 45.688 us/op | |
Iteration 8: 45.835 us/op | |
Iteration 9: 46.425 us/op | |
Iteration 10: 46.054 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
45.720 ±(99.9%) 0.470 us/op [Average] | |
(min, avg, max) = (45.368, 45.720, 46.425), stdev = 0.311 | |
CI (99.9%): [45.250, 46.191] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 14.29% complete, ETA 00:06:06 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 49.819 us/op | |
# Warmup Iteration 2: 42.920 us/op | |
# Warmup Iteration 3: 43.265 us/op | |
# Warmup Iteration 4: 42.590 us/op | |
# Warmup Iteration 5: 42.464 us/op | |
# Warmup Iteration 6: 42.471 us/op | |
# Warmup Iteration 7: 42.327 us/op | |
# Warmup Iteration 8: 42.466 us/op | |
# Warmup Iteration 9: 42.713 us/op | |
# Warmup Iteration 10: 42.174 us/op | |
Iteration 1: 42.288 us/op | |
Iteration 2: 42.417 us/op | |
Iteration 3: 42.542 us/op | |
Iteration 4: 42.581 us/op | |
Iteration 5: 42.299 us/op | |
Iteration 6: 42.363 us/op | |
Iteration 7: 42.266 us/op | |
Iteration 8: 42.423 us/op | |
Iteration 9: 42.857 us/op | |
Iteration 10: 42.283 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
42.432 ±(99.9%) 0.280 us/op [Average] | |
(min, avg, max) = (42.266, 42.432, 42.857), stdev = 0.185 | |
CI (99.9%): [42.152, 42.712] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 19.05% complete, ETA 00:05:46 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
59.165 us/op | |
# Warmup Iteration 2: 50.179 us/op | |
# Warmup Iteration 3: 49.797 us/op | |
# Warmup Iteration 4: 49.804 us/op | |
# Warmup Iteration 5: 49.594 us/op | |
# Warmup Iteration 6: 51.304 us/op | |
# Warmup Iteration 7: 50.252 us/op | |
# Warmup Iteration 8: 50.718 us/op | |
# Warmup Iteration 9: 49.667 us/op | |
# Warmup Iteration 10: 49.775 us/op | |
Iteration 1: 49.882 us/op | |
Iteration 2: 49.510 us/op | |
Iteration 3: 49.844 us/op | |
Iteration 4: 49.347 us/op | |
Iteration 5: 50.175 us/op | |
Iteration 6: 49.832 us/op | |
Iteration 7: 50.230 us/op | |
Iteration 8: 50.210 us/op | |
Iteration 9: 50.029 us/op | |
Iteration 10: 50.563 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
49.962 ±(99.9%) 0.544 us/op [Average] | |
(min, avg, max) = (49.347, 49.962, 50.563), stdev = 0.360 | |
CI (99.9%): [49.419, 50.506] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 23.81% complete, ETA 00:05:26 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 52.983 us/op | |
# Warmup Iteration 2: 45.869 us/op | |
# Warmup Iteration 3: 46.499 us/op | |
# Warmup Iteration 4: 45.582 us/op | |
# Warmup Iteration 5: 45.320 us/op | |
# Warmup Iteration 6: 47.767 us/op | |
# Warmup Iteration 7: 45.328 us/op | |
# Warmup Iteration 8: 45.585 us/op | |
# Warmup Iteration 9: 45.486 us/op | |
# Warmup Iteration 10: 45.083 us/op | |
Iteration 1: 45.110 us/op | |
Iteration 2: 45.292 us/op | |
Iteration 3: 45.328 us/op | |
Iteration 4: 45.176 us/op | |
Iteration 5: 45.078 us/op | |
Iteration 6: 45.674 us/op | |
Iteration 7: 49.051 us/op | |
Iteration 8: 46.949 us/op | |
Iteration 9: 45.760 us/op | |
Iteration 10: 45.223 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
45.864 ±(99.9%) 1.890 us/op [Average] | |
(min, avg, max) = (45.078, 45.864, 49.051), stdev = 1.250 | |
CI (99.9%): [43.974, 47.754] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 28.57% complete, ETA 00:05:05 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 49.065 us/op | |
# Warmup Iteration 2: 42.788 us/op | |
# Warmup Iteration 3: 42.430 us/op | |
# Warmup Iteration 4: 41.807 us/op | |
# Warmup Iteration 5: 41.955 us/op | |
# Warmup Iteration 6: 42.139 us/op | |
# Warmup Iteration 7: 42.460 us/op | |
# Warmup Iteration 8: 42.173 us/op | |
# Warmup Iteration 9: 41.738 us/op | |
# Warmup Iteration 10: 42.040 us/op | |
Iteration 1: 41.905 us/op | |
Iteration 2: 42.721 us/op | |
Iteration 3: 42.090 us/op | |
Iteration 4: 44.390 us/op | |
Iteration 5: 42.910 us/op | |
Iteration 6: 42.492 us/op | |
Iteration 7: 42.141 us/op | |
Iteration 8: 41.975 us/op | |
Iteration 9: 42.064 us/op | |
Iteration 10: 41.823 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
42.451 ±(99.9%) 1.164 us/op [Average] | |
(min, avg, max) = (41.823, 42.451, 44.390), stdev = 0.770 | |
CI (99.9%): [41.287, 43.616] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 33.33% complete, ETA 00:04:45 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 102.250 us/op | |
# Warmup Iteration 2: 91.605 us/op | |
# Warmup Iteration 3: 91.649 us/op | |
# Warmup Iteration 4: 91.190 us/op | |
# Warmup Iteration 5: 91.452 us/op | |
# Warmup Iteration 6: 93.009 us/op | |
# Warmup Iteration 7: 92.277 us/op | |
# Warmup Iteration 8: 92.388 us/op | |
# Warmup Iteration 9: 91.705 us/op | |
# Warmup Iteration 10: 91.109 us/op | |
Iteration 1: 90.921 us/op | |
Iteration 2: 91.102 us/op | |
Iteration 3: 91.031 us/op | |
Iteration 4: 90.756 us/op | |
Iteration 5: 90.807 us/op | |
Iteration 6: 90.799 us/op | |
Iteration 7: 91.801 us/op | |
Iteration 8: 91.107 us/op | |
Iteration 9: 90.984 us/op | |
Iteration 10: 90.796 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
91.010 ±(99.9%) 0.464 us/op [Average] | |
(min, avg, max) = (90.756, 91.010, 91.801), stdev = 0.307 | |
CI (99.9%): [90.546, 91.475] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 38.10% complete, ETA 00:04:25 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 115.710 us/op | |
# Warmup Iteration 2: 100.984 us/op | |
# Warmup Iteration 3: 100.019 us/op | |
# Warmup Iteration 4: 101.716 us/op | |
# Warmup Iteration 5: 100.014 us/op | |
# Warmup Iteration 6: 101.062 us/op | |
# Warmup Iteration 7: 100.766 us/op | |
# Warmup Iteration 8: 102.794 us/op | |
# Warmup Iteration 9: 101.333 us/op | |
# Warmup Iteration 10: 100.242 us/op | |
Iteration 1: 100.849 us/op | |
Iteration 2: 101.502 us/op | |
Iteration 3: 99.535 us/op | |
Iteration 4: 99.412 us/op | |
Iteration 5: 99.080 us/op | |
Iteration 6: 99.968 us/op | |
Iteration 7: 100.980 us/op | |
Iteration 8: 100.237 us/op | |
Iteration 9: 109.217 us/op | |
Iteration 10: 118.729 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
102.951 ±(99.9%) 9.483 us/op [Average] | |
(min, avg, max) = (99.080, 102.951, 118.729), stdev = 6.272 | |
CI (99.9%): [93.468, 112.433] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 42.86% complete, ETA 00:04:04 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 224.894 us/op | |
# Warmup Iteration 2: 202.214 us/op | |
# Warmup Iteration 3: 199.730 us/op | |
# Warmup Iteration 4: 201.013 us/op | |
# Warmup Iteration 5: 201.024 us/op | |
# Warmup Iteration 6: 201.737 us/op | |
# Warmup Iteration 7: 205.531 us/op | |
# Warmup Iteration 8: 202.024 us/op | |
# Warmup Iteration 9: 199.923 us/op | |
# Warmup Iteration 10: 199.822 us/op | |
Iteration 1: 200.492 us/op | |
Iteration 2: 201.278 us/op | |
Iteration 3: 203.528 us/op | |
Iteration 4: 198.846 us/op | |
Iteration 5: 198.960 us/op | |
Iteration 6: 201.262 us/op | |
Iteration 7: 200.860 us/op | |
Iteration 8: 199.543 us/op | |
Iteration 9: 199.185 us/op | |
Iteration 10: 199.107 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
200.306 ±(99.9%) 2.242 us/op [Average] | |
(min, avg, max) = (198.846, 200.306, 203.528), stdev = 1.483 | |
CI (99.9%): [198.064, 202.548] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 47.62% complete, ETA 00:03:44 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 111.127 us/op | |
# Warmup Iteration 2: 100.155 us/op | |
# Warmup Iteration 3: 101.714 us/op | |
# Warmup Iteration 4: 100.137 us/op | |
# Warmup Iteration 5: 104.336 us/op | |
# Warmup Iteration 6: 102.577 us/op | |
# Warmup Iteration 7: 101.739 us/op | |
# Warmup Iteration 8: 100.076 us/op | |
# Warmup Iteration 9: 99.808 us/op | |
# Warmup Iteration 10: 99.707 us/op | |
Iteration 1: 100.279 us/op | |
Iteration 2: 99.108 us/op | |
Iteration 3: 98.517 us/op | |
Iteration 4: 98.380 us/op | |
Iteration 5: 99.165 us/op | |
Iteration 6: 101.866 us/op | |
Iteration 7: 99.100 us/op | |
Iteration 8: 98.413 us/op | |
Iteration 9: 98.195 us/op | |
Iteration 10: 98.375 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
99.140 ±(99.9%) 1.724 us/op [Average] | |
(min, avg, max) = (98.195, 99.140, 101.866), stdev = 1.140 | |
CI (99.9%): [97.416, 100.864] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 52.38% complete, ETA 00:03:23 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
290.953 us/op | |
# Warmup Iteration 2: 258.766 us/op | |
# Warmup Iteration 3: 254.969 us/op | |
# Warmup Iteration 4: 254.420 us/op | |
# Warmup Iteration 5: 255.514 us/op | |
# Warmup Iteration 6: 253.914 us/op | |
# Warmup Iteration 7: 256.734 us/op | |
# Warmup Iteration 8: 257.640 us/op | |
# Warmup Iteration 9: 256.990 us/op | |
# Warmup Iteration 10: 258.108 us/op | |
Iteration 1: 254.040 us/op | |
Iteration 2: 254.276 us/op | |
Iteration 3: 254.668 us/op | |
Iteration 4: 257.199 us/op | |
Iteration 5: 264.337 us/op | |
Iteration 6: 258.830 us/op | |
Iteration 7: 253.781 us/op | |
Iteration 8: 254.416 us/op | |
Iteration 9: 254.431 us/op | |
Iteration 10: 255.904 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
256.188 ±(99.9%) 4.966 us/op [Average] | |
(min, avg, max) = (253.781, 256.188, 264.337), stdev = 3.285 | |
CI (99.9%): [251.222, 261.154] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 57.14% complete, ETA 00:03:03 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 122.108 us/op | |
# Warmup Iteration 2: 107.842 us/op | |
# Warmup Iteration 3: 107.534 us/op | |
# Warmup Iteration 4: 106.653 us/op | |
# Warmup Iteration 5: 106.558 us/op | |
# Warmup Iteration 6: 105.625 us/op | |
# Warmup Iteration 7: 105.959 us/op | |
# Warmup Iteration 8: 105.890 us/op | |
# Warmup Iteration 9: 105.838 us/op | |
# Warmup Iteration 10: 106.071 us/op | |
Iteration 1: 105.816 us/op | |
Iteration 2: 106.644 us/op | |
Iteration 3: 107.331 us/op | |
Iteration 4: 106.615 us/op | |
Iteration 5: 105.989 us/op | |
Iteration 6: 106.954 us/op | |
Iteration 7: 106.627 us/op | |
Iteration 8: 107.380 us/op | |
Iteration 9: 106.227 us/op | |
Iteration 10: 106.545 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
106.613 ±(99.9%) 0.781 us/op [Average] | |
(min, avg, max) = (105.816, 106.613, 107.380), stdev = 0.516 | |
CI (99.9%): [105.833, 107.394] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 61.90% complete, ETA 00:02:43 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 95.071 us/op | |
# Warmup Iteration 2: 85.610 us/op | |
# Warmup Iteration 3: 86.193 us/op | |
# Warmup Iteration 4: 86.927 us/op | |
# Warmup Iteration 5: 87.542 us/op | |
# Warmup Iteration 6: 86.109 us/op | |
# Warmup Iteration 7: 87.482 us/op | |
# Warmup Iteration 8: 87.071 us/op | |
# Warmup Iteration 9: 85.956 us/op | |
# Warmup Iteration 10: 85.429 us/op | |
Iteration 1: 85.697 us/op | |
Iteration 2: 85.885 us/op | |
Iteration 3: 87.468 us/op | |
Iteration 4: 88.522 us/op | |
Iteration 5: 87.155 us/op | |
Iteration 6: 86.117 us/op | |
Iteration 7: 86.009 us/op | |
Iteration 8: 86.263 us/op | |
Iteration 9: 85.643 us/op | |
Iteration 10: 87.189 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
86.595 ±(99.9%) 1.429 us/op [Average] | |
(min, avg, max) = (85.643, 86.595, 88.522), stdev = 0.945 | |
CI (99.9%): [85.166, 88.024] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 66.67% complete, ETA 00:02:22 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 162.212 us/op | |
# Warmup Iteration 2: 140.547 us/op | |
# Warmup Iteration 3: 139.324 us/op | |
# Warmup Iteration 4: 137.394 us/op | |
# Warmup Iteration 5: 137.194 us/op | |
# Warmup Iteration 6: 138.373 us/op | |
# Warmup Iteration 7: 137.575 us/op | |
# Warmup Iteration 8: 138.946 us/op | |
# Warmup Iteration 9: 139.878 us/op | |
# Warmup Iteration 10: 140.243 us/op | |
Iteration 1: 139.803 us/op | |
Iteration 2: 142.004 us/op | |
Iteration 3: 142.027 us/op | |
Iteration 4: 145.059 us/op | |
Iteration 5: 143.230 us/op | |
Iteration 6: 141.373 us/op | |
Iteration 7: 141.340 us/op | |
Iteration 8: 140.718 us/op | |
Iteration 9: 138.542 us/op | |
Iteration 10: 138.593 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
141.269 ±(99.9%) 3.040 us/op [Average] | |
(min, avg, max) = (138.542, 141.269, 145.059), stdev = 2.011 | |
CI (99.9%): [138.229, 144.309] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 71.43% complete, ETA 00:02:02 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 182.625 us/op | |
# Warmup Iteration 2: 157.696 us/op | |
# Warmup Iteration 3: 161.481 us/op | |
# Warmup Iteration 4: 162.945 us/op | |
# Warmup Iteration 5: 155.457 us/op | |
# Warmup Iteration 6: 154.486 us/op | |
# Warmup Iteration 7: 154.989 us/op | |
# Warmup Iteration 8: 157.527 us/op | |
# Warmup Iteration 9: 155.980 us/op | |
# Warmup Iteration 10: 154.452 us/op | |
Iteration 1: 156.229 us/op | |
Iteration 2: 157.284 us/op | |
Iteration 3: 157.506 us/op | |
Iteration 4: 159.260 us/op | |
Iteration 5: 156.452 us/op | |
Iteration 6: 155.617 us/op | |
Iteration 7: 154.512 us/op | |
Iteration 8: 154.234 us/op | |
Iteration 9: 156.513 us/op | |
Iteration 10: 153.846 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
156.145 ±(99.9%) 2.518 us/op [Average] | |
(min, avg, max) = (153.846, 156.145, 159.260), stdev = 1.666 | |
CI (99.9%): [153.627, 158.663] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 76.19% complete, ETA 00:01:41 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 392.840 us/op | |
# Warmup Iteration 2: 366.864 us/op | |
# Warmup Iteration 3: 362.300 us/op | |
# Warmup Iteration 4: 359.312 us/op | |
# Warmup Iteration 5: 355.202 us/op | |
# Warmup Iteration 6: 352.309 us/op | |
# Warmup Iteration 7: 352.318 us/op | |
# Warmup Iteration 8: 352.686 us/op | |
# Warmup Iteration 9: 359.892 us/op | |
# Warmup Iteration 10: 358.549 us/op | |
Iteration 1: 355.547 us/op | |
Iteration 2: 359.818 us/op | |
Iteration 3: 358.531 us/op | |
Iteration 4: 357.858 us/op | |
Iteration 5: 359.259 us/op | |
Iteration 6: 354.035 us/op | |
Iteration 7: 355.518 us/op | |
Iteration 8: 356.927 us/op | |
Iteration 9: 358.793 us/op | |
Iteration 10: 370.431 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
358.672 ±(99.9%) 6.852 us/op [Average] | |
(min, avg, max) = (354.035, 358.672, 370.431), stdev = 4.532 | |
CI (99.9%): [351.819, 365.524] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 80.95% complete, ETA 00:01:21 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 173.056 us/op | |
# Warmup Iteration 2: 153.110 us/op | |
# Warmup Iteration 3: 157.436 us/op | |
# Warmup Iteration 4: 153.856 us/op | |
# Warmup Iteration 5: 152.445 us/op | |
# Warmup Iteration 6: 152.842 us/op | |
# Warmup Iteration 7: 149.298 us/op | |
# Warmup Iteration 8: 150.568 us/op | |
# Warmup Iteration 9: 149.370 us/op | |
# Warmup Iteration 10: 149.747 us/op | |
Iteration 1: 150.322 us/op | |
Iteration 2: 149.241 us/op | |
Iteration 3: 154.225 us/op | |
Iteration 4: 152.373 us/op | |
Iteration 5: 153.599 us/op | |
Iteration 6: 152.486 us/op | |
Iteration 7: 151.236 us/op | |
Iteration 8: 153.026 us/op | |
Iteration 9: 151.792 us/op | |
Iteration 10: 151.627 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
151.993 ±(99.9%) 2.261 us/op [Average] | |
(min, avg, max) = (149.241, 151.993, 154.225), stdev = 1.496 | |
CI (99.9%): [149.732, 154.254] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 85.71% complete, ETA 00:01:01 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
543.338 us/op | |
# Warmup Iteration 2: 480.713 us/op | |
# Warmup Iteration 3: 479.672 us/op | |
# Warmup Iteration 4: 484.202 us/op | |
# Warmup Iteration 5: 486.259 us/op | |
# Warmup Iteration 6: 476.297 us/op | |
# Warmup Iteration 7: 472.982 us/op | |
# Warmup Iteration 8: 473.707 us/op | |
# Warmup Iteration 9: 473.438 us/op | |
# Warmup Iteration 10: 475.029 us/op | |
Iteration 1: 477.855 us/op | |
Iteration 2: 484.674 us/op | |
Iteration 3: 478.405 us/op | |
Iteration 4: 470.887 us/op | |
Iteration 5: 472.762 us/op | |
Iteration 6: 475.340 us/op | |
Iteration 7: 493.066 us/op | |
Iteration 8: 472.735 us/op | |
Iteration 9: 488.077 us/op | |
Iteration 10: 483.012 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
479.681 ±(99.9%) 11.075 us/op [Average] | |
(min, avg, max) = (470.887, 479.681, 493.066), stdev = 7.325 | |
CI (99.9%): [468.607, 490.756] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 90.48% complete, ETA 00:00:40 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 194.178 us/op | |
# Warmup Iteration 2: 172.348 us/op | |
# Warmup Iteration 3: 167.797 us/op | |
# Warmup Iteration 4: 166.072 us/op | |
# Warmup Iteration 5: 165.569 us/op | |
# Warmup Iteration 6: 165.921 us/op | |
# Warmup Iteration 7: 166.205 us/op | |
# Warmup Iteration 8: 165.804 us/op | |
# Warmup Iteration 9: 166.801 us/op | |
# Warmup Iteration 10: 167.080 us/op | |
Iteration 1: 166.708 us/op | |
Iteration 2: 170.733 us/op | |
Iteration 3: 171.510 us/op | |
Iteration 4: 169.848 us/op | |
Iteration 5: 166.356 us/op | |
Iteration 6: 165.579 us/op | |
Iteration 7: 166.195 us/op | |
Iteration 8: 166.033 us/op | |
Iteration 9: 166.789 us/op | |
Iteration 10: 166.130 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
167.588 ±(99.9%) 3.336 us/op [Average] | |
(min, avg, max) = (165.579, 167.588, 171.510), stdev = 2.207 | |
CI (99.9%): [164.252, 170.925] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 95.24% complete, ETA 00:00:20 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 141.866 us/op | |
# Warmup Iteration 2: 128.143 us/op | |
# Warmup Iteration 3: 128.349 us/op | |
# Warmup Iteration 4: 128.459 us/op | |
# Warmup Iteration 5: 127.438 us/op | |
# Warmup Iteration 6: 127.511 us/op | |
# Warmup Iteration 7: 128.000 us/op | |
# Warmup Iteration 8: 127.587 us/op | |
# Warmup Iteration 9: 128.485 us/op | |
# Warmup Iteration 10: 128.884 us/op | |
Iteration 1: 129.248 us/op | |
Iteration 2: 128.219 us/op | |
Iteration 3: 127.856 us/op | |
Iteration 4: 127.893 us/op | |
Iteration 5: 127.327 us/op | |
Iteration 6: 127.121 us/op | |
Iteration 7: 127.137 us/op | |
Iteration 8: 127.304 us/op | |
Iteration 9: 127.121 us/op | |
Iteration 10: 127.694 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
127.692 ±(99.9%) 1.009 us/op [Average] | |
(min, avg, max) = (127.121, 127.692, 129.248), stdev = 0.667 | |
CI (99.9%): [126.683, 128.701] (assumes normal distribution) | |
# Run complete. Total time: 00:07:08 | |
Benchmark (columnIndexType) (getter) (ncols) (nrows) (reuseStatement) (type) (unique) Mode Cnt Score Error Units | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false INT false avgt 10 41.712 ± 0.372 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BIGINT false avgt 10 43.158 ± 1.569 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BIGDECIMAL false avgt 10 45.720 ± 0.470 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false STRING false avgt 10 42.432 ± 0.280 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false TIMESTAMP false avgt 10 49.962 ± 0.544 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false TIMESTAMPTZ false avgt 10 45.864 ± 1.890 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BOOL false avgt 10 42.451 ± 1.164 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false INT false avgt 10 91.010 ± 0.464 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BIGINT false avgt 10 102.951 ± 9.483 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BIGDECIMAL false avgt 10 200.306 ± 2.242 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false STRING false avgt 10 99.140 ± 1.724 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false TIMESTAMP false avgt 10 256.188 ± 4.966 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false TIMESTAMPTZ false avgt 10 106.613 ± 0.781 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BOOL false avgt 10 86.595 ± 1.429 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false INT false avgt 10 141.269 ± 3.040 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BIGINT false avgt 10 156.145 ± 2.518 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BIGDECIMAL false avgt 10 358.672 ± 6.852 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false STRING false avgt 10 151.993 ± 2.261 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false TIMESTAMP false avgt 10 479.681 ± 11.075 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false TIMESTAMPTZ false avgt 10 167.588 ± 3.336 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BOOL false avgt 10 127.692 ± 1.009 us/op |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 0.00% complete, ETA 00:07:00 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 47.525 us/op | |
# Warmup Iteration 2: 42.424 us/op | |
# Warmup Iteration 3: 42.265 us/op | |
# Warmup Iteration 4: 41.544 us/op | |
# Warmup Iteration 5: 41.577 us/op | |
# Warmup Iteration 6: 41.613 us/op | |
# Warmup Iteration 7: 44.459 us/op | |
# Warmup Iteration 8: 45.824 us/op | |
# Warmup Iteration 9: 42.613 us/op | |
# Warmup Iteration 10: 41.789 us/op | |
Iteration 1: 41.581 us/op | |
Iteration 2: 42.556 us/op | |
Iteration 3: 42.356 us/op | |
Iteration 4: 42.218 us/op | |
Iteration 5: 41.878 us/op | |
Iteration 6: 42.170 us/op | |
Iteration 7: 42.228 us/op | |
Iteration 8: 41.861 us/op | |
Iteration 9: 41.504 us/op | |
Iteration 10: 41.348 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
41.970 ±(99.9%) 0.604 us/op [Average] | |
(min, avg, max) = (41.348, 41.970, 42.556), stdev = 0.399 | |
CI (99.9%): [41.366, 42.574] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 4.76% complete, ETA 00:06:46 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 50.556 us/op | |
# Warmup Iteration 2: 43.617 us/op | |
# Warmup Iteration 3: 43.724 us/op | |
# Warmup Iteration 4: 43.581 us/op | |
# Warmup Iteration 5: 43.215 us/op | |
# Warmup Iteration 6: 43.152 us/op | |
# Warmup Iteration 7: 43.337 us/op | |
# Warmup Iteration 8: 43.783 us/op | |
# Warmup Iteration 9: 43.057 us/op | |
# Warmup Iteration 10: 43.401 us/op | |
Iteration 1: 43.198 us/op | |
Iteration 2: 43.013 us/op | |
Iteration 3: 43.404 us/op | |
Iteration 4: 43.274 us/op | |
Iteration 5: 42.999 us/op | |
Iteration 6: 42.900 us/op | |
Iteration 7: 43.550 us/op | |
Iteration 8: 45.181 us/op | |
Iteration 9: 43.812 us/op | |
Iteration 10: 43.644 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
43.498 ±(99.9%) 1.001 us/op [Average] | |
(min, avg, max) = (42.900, 43.498, 45.181), stdev = 0.662 | |
CI (99.9%): [42.496, 44.499] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 9.52% complete, ETA 00:06:27 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 54.006 us/op | |
# Warmup Iteration 2: 45.774 us/op | |
# Warmup Iteration 3: 45.826 us/op | |
# Warmup Iteration 4: 45.674 us/op | |
# Warmup Iteration 5: 45.756 us/op | |
# Warmup Iteration 6: 45.416 us/op | |
# Warmup Iteration 7: 45.776 us/op | |
# Warmup Iteration 8: 45.643 us/op | |
# Warmup Iteration 9: 45.608 us/op | |
# Warmup Iteration 10: 45.448 us/op | |
Iteration 1: 45.460 us/op | |
Iteration 2: 45.378 us/op | |
Iteration 3: 45.769 us/op | |
Iteration 4: 45.205 us/op | |
Iteration 5: 45.553 us/op | |
Iteration 6: 45.257 us/op | |
Iteration 7: 45.491 us/op | |
Iteration 8: 45.246 us/op | |
Iteration 9: 45.287 us/op | |
Iteration 10: 45.247 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
45.389 ±(99.9%) 0.271 us/op [Average] | |
(min, avg, max) = (45.205, 45.389, 45.769), stdev = 0.179 | |
CI (99.9%): [45.118, 45.660] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 14.29% complete, ETA 00:06:06 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 50.003 us/op | |
# Warmup Iteration 2: 42.905 us/op | |
# Warmup Iteration 3: 43.107 us/op | |
# Warmup Iteration 4: 42.319 us/op | |
# Warmup Iteration 5: 42.631 us/op | |
# Warmup Iteration 6: 42.987 us/op | |
# Warmup Iteration 7: 42.620 us/op | |
# Warmup Iteration 8: 43.019 us/op | |
# Warmup Iteration 9: 42.745 us/op | |
# Warmup Iteration 10: 42.131 us/op | |
Iteration 1: 42.276 us/op | |
Iteration 2: 42.651 us/op | |
Iteration 3: 43.014 us/op | |
Iteration 4: 42.457 us/op | |
Iteration 5: 42.118 us/op | |
Iteration 6: 42.440 us/op | |
Iteration 7: 43.401 us/op | |
Iteration 8: 42.974 us/op | |
Iteration 9: 42.400 us/op | |
Iteration 10: 43.297 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
42.703 ±(99.9%) 0.668 us/op [Average] | |
(min, avg, max) = (42.118, 42.703, 43.401), stdev = 0.442 | |
CI (99.9%): [42.034, 43.371] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 19.05% complete, ETA 00:05:46 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
60.380 us/op | |
# Warmup Iteration 2: 52.009 us/op | |
# Warmup Iteration 3: 49.959 us/op | |
# Warmup Iteration 4: 50.223 us/op | |
# Warmup Iteration 5: 49.967 us/op | |
# Warmup Iteration 6: 49.755 us/op | |
# Warmup Iteration 7: 49.730 us/op | |
# Warmup Iteration 8: 49.743 us/op | |
# Warmup Iteration 9: 49.863 us/op | |
# Warmup Iteration 10: 49.741 us/op | |
Iteration 1: 50.028 us/op | |
Iteration 2: 51.071 us/op | |
Iteration 3: 49.883 us/op | |
Iteration 4: 49.598 us/op | |
Iteration 5: 49.628 us/op | |
Iteration 6: 50.380 us/op | |
Iteration 7: 51.722 us/op | |
Iteration 8: 52.427 us/op | |
Iteration 9: 49.879 us/op | |
Iteration 10: 52.873 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
50.749 ±(99.9%) 1.825 us/op [Average] | |
(min, avg, max) = (49.598, 50.749, 52.873), stdev = 1.207 | |
CI (99.9%): [48.923, 52.574] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 23.81% complete, ETA 00:05:26 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 53.391 us/op | |
# Warmup Iteration 2: 46.392 us/op | |
# Warmup Iteration 3: 46.728 us/op | |
# Warmup Iteration 4: 46.724 us/op | |
# Warmup Iteration 5: 47.049 us/op | |
# Warmup Iteration 6: 46.758 us/op | |
# Warmup Iteration 7: 46.925 us/op | |
# Warmup Iteration 8: 45.768 us/op | |
# Warmup Iteration 9: 45.620 us/op | |
# Warmup Iteration 10: 46.235 us/op | |
Iteration 1: 46.615 us/op | |
Iteration 2: 46.392 us/op | |
Iteration 3: 47.881 us/op | |
Iteration 4: 46.825 us/op | |
Iteration 5: 46.585 us/op | |
Iteration 6: 45.754 us/op | |
Iteration 7: 45.477 us/op | |
Iteration 8: 46.053 us/op | |
Iteration 9: 45.730 us/op | |
Iteration 10: 46.157 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
46.347 ±(99.9%) 1.048 us/op [Average] | |
(min, avg, max) = (45.477, 46.347, 47.881), stdev = 0.693 | |
CI (99.9%): [45.299, 47.395] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 1, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 28.57% complete, ETA 00:05:05 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 48.778 us/op | |
# Warmup Iteration 2: 42.775 us/op | |
# Warmup Iteration 3: 41.977 us/op | |
# Warmup Iteration 4: 41.938 us/op | |
# Warmup Iteration 5: 43.104 us/op | |
# Warmup Iteration 6: 43.124 us/op | |
# Warmup Iteration 7: 42.795 us/op | |
# Warmup Iteration 8: 41.762 us/op | |
# Warmup Iteration 9: 41.538 us/op | |
# Warmup Iteration 10: 41.841 us/op | |
Iteration 1: 41.708 us/op | |
Iteration 2: 41.610 us/op | |
Iteration 3: 41.739 us/op | |
Iteration 4: 41.888 us/op | |
Iteration 5: 41.882 us/op | |
Iteration 6: 41.953 us/op | |
Iteration 7: 41.481 us/op | |
Iteration 8: 41.581 us/op | |
Iteration 9: 41.563 us/op | |
Iteration 10: 41.585 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
41.699 ±(99.9%) 0.245 us/op [Average] | |
(min, avg, max) = (41.481, 41.699, 41.953), stdev = 0.162 | |
CI (99.9%): [41.454, 41.944] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 33.33% complete, ETA 00:04:45 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 101.990 us/op | |
# Warmup Iteration 2: 91.296 us/op | |
# Warmup Iteration 3: 90.850 us/op | |
# Warmup Iteration 4: 91.330 us/op | |
# Warmup Iteration 5: 91.973 us/op | |
# Warmup Iteration 6: 90.856 us/op | |
# Warmup Iteration 7: 90.956 us/op | |
# Warmup Iteration 8: 90.689 us/op | |
# Warmup Iteration 9: 90.943 us/op | |
# Warmup Iteration 10: 90.727 us/op | |
Iteration 1: 90.973 us/op | |
Iteration 2: 90.595 us/op | |
Iteration 3: 90.742 us/op | |
Iteration 4: 91.204 us/op | |
Iteration 5: 93.110 us/op | |
Iteration 6: 91.284 us/op | |
Iteration 7: 91.830 us/op | |
Iteration 8: 90.497 us/op | |
Iteration 9: 90.767 us/op | |
Iteration 10: 91.083 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
91.209 ±(99.9%) 1.168 us/op [Average] | |
(min, avg, max) = (90.497, 91.209, 93.110), stdev = 0.773 | |
CI (99.9%): [90.040, 92.377] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 38.10% complete, ETA 00:04:25 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 112.959 us/op | |
# Warmup Iteration 2: 99.764 us/op | |
# Warmup Iteration 3: 99.736 us/op | |
# Warmup Iteration 4: 101.261 us/op | |
# Warmup Iteration 5: 101.064 us/op | |
# Warmup Iteration 6: 100.605 us/op | |
# Warmup Iteration 7: 99.992 us/op | |
# Warmup Iteration 8: 99.662 us/op | |
# Warmup Iteration 9: 99.589 us/op | |
# Warmup Iteration 10: 100.144 us/op | |
Iteration 1: 99.891 us/op | |
Iteration 2: 99.452 us/op | |
Iteration 3: 99.762 us/op | |
Iteration 4: 99.663 us/op | |
Iteration 5: 100.293 us/op | |
Iteration 6: 99.938 us/op | |
Iteration 7: 99.842 us/op | |
Iteration 8: 99.531 us/op | |
Iteration 9: 99.474 us/op | |
Iteration 10: 100.130 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
99.798 ±(99.9%) 0.422 us/op [Average] | |
(min, avg, max) = (99.452, 99.798, 100.293), stdev = 0.279 | |
CI (99.9%): [99.376, 100.219] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 42.86% complete, ETA 00:04:04 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 229.190 us/op | |
# Warmup Iteration 2: 206.472 us/op | |
# Warmup Iteration 3: 199.675 us/op | |
# Warmup Iteration 4: 200.674 us/op | |
# Warmup Iteration 5: 202.074 us/op | |
# Warmup Iteration 6: 199.629 us/op | |
# Warmup Iteration 7: 200.469 us/op | |
# Warmup Iteration 8: 198.050 us/op | |
# Warmup Iteration 9: 198.118 us/op | |
# Warmup Iteration 10: 197.518 us/op | |
Iteration 1: 198.460 us/op | |
Iteration 2: 198.519 us/op | |
Iteration 3: 197.499 us/op | |
Iteration 4: 197.893 us/op | |
Iteration 5: 197.153 us/op | |
Iteration 6: 197.451 us/op | |
Iteration 7: 198.047 us/op | |
Iteration 8: 197.784 us/op | |
Iteration 9: 198.230 us/op | |
Iteration 10: 198.533 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
197.957 ±(99.9%) 0.735 us/op [Average] | |
(min, avg, max) = (197.153, 197.957, 198.533), stdev = 0.486 | |
CI (99.9%): [197.221, 198.692] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 47.62% complete, ETA 00:03:44 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 110.677 us/op | |
# Warmup Iteration 2: 99.032 us/op | |
# Warmup Iteration 3: 99.309 us/op | |
# Warmup Iteration 4: 99.412 us/op | |
# Warmup Iteration 5: 98.848 us/op | |
# Warmup Iteration 6: 99.562 us/op | |
# Warmup Iteration 7: 99.282 us/op | |
# Warmup Iteration 8: 99.131 us/op | |
# Warmup Iteration 9: 99.306 us/op | |
# Warmup Iteration 10: 99.657 us/op | |
Iteration 1: 99.349 us/op | |
Iteration 2: 99.453 us/op | |
Iteration 3: 98.173 us/op | |
Iteration 4: 102.680 us/op | |
Iteration 5: 101.339 us/op | |
Iteration 6: 99.600 us/op | |
Iteration 7: 97.782 us/op | |
Iteration 8: 97.760 us/op | |
Iteration 9: 98.242 us/op | |
Iteration 10: 97.837 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
99.222 ±(99.9%) 2.512 us/op [Average] | |
(min, avg, max) = (97.760, 99.222, 102.680), stdev = 1.661 | |
CI (99.9%): [96.710, 101.733] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 52.38% complete, ETA 00:03:23 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
290.103 us/op | |
# Warmup Iteration 2: 258.617 us/op | |
# Warmup Iteration 3: 254.951 us/op | |
# Warmup Iteration 4: 255.652 us/op | |
# Warmup Iteration 5: 260.566 us/op | |
# Warmup Iteration 6: 257.923 us/op | |
# Warmup Iteration 7: 259.457 us/op | |
# Warmup Iteration 8: 259.667 us/op | |
# Warmup Iteration 9: 261.789 us/op | |
# Warmup Iteration 10: 261.040 us/op | |
Iteration 1: 258.730 us/op | |
Iteration 2: 255.994 us/op | |
Iteration 3: 255.181 us/op | |
Iteration 4: 255.191 us/op | |
Iteration 5: 254.718 us/op | |
Iteration 6: 254.767 us/op | |
Iteration 7: 254.476 us/op | |
Iteration 8: 255.361 us/op | |
Iteration 9: 265.070 us/op | |
Iteration 10: 257.867 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
256.735 ±(99.9%) 4.912 us/op [Average] | |
(min, avg, max) = (254.476, 256.735, 265.070), stdev = 3.249 | |
CI (99.9%): [251.823, 261.648] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 57.14% complete, ETA 00:03:03 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 121.649 us/op | |
# Warmup Iteration 2: 106.966 us/op | |
# Warmup Iteration 3: 108.392 us/op | |
# Warmup Iteration 4: 107.601 us/op | |
# Warmup Iteration 5: 107.976 us/op | |
# Warmup Iteration 6: 107.495 us/op | |
# Warmup Iteration 7: 107.752 us/op | |
# Warmup Iteration 8: 107.282 us/op | |
# Warmup Iteration 9: 106.520 us/op | |
# Warmup Iteration 10: 108.912 us/op | |
Iteration 1: 109.390 us/op | |
Iteration 2: 109.193 us/op | |
Iteration 3: 108.901 us/op | |
Iteration 4: 106.731 us/op | |
Iteration 5: 106.572 us/op | |
Iteration 6: 106.383 us/op | |
Iteration 7: 106.468 us/op | |
Iteration 8: 106.119 us/op | |
Iteration 9: 106.632 us/op | |
Iteration 10: 106.186 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
107.258 ±(99.9%) 2.014 us/op [Average] | |
(min, avg, max) = (106.119, 107.258, 109.390), stdev = 1.332 | |
CI (99.9%): [105.244, 109.271] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 50, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 61.90% complete, ETA 00:02:43 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 95.811 us/op | |
# Warmup Iteration 2: 86.047 us/op | |
# Warmup Iteration 3: 86.822 us/op | |
# Warmup Iteration 4: 86.019 us/op | |
# Warmup Iteration 5: 89.974 us/op | |
# Warmup Iteration 6: 86.437 us/op | |
# Warmup Iteration 7: 86.687 us/op | |
# Warmup Iteration 8: 88.952 us/op | |
# Warmup Iteration 9: 87.099 us/op | |
# Warmup Iteration 10: 87.557 us/op | |
Iteration 1: 87.145 us/op | |
Iteration 2: 88.010 us/op | |
Iteration 3: 90.380 us/op | |
Iteration 4: 89.231 us/op | |
Iteration 5: 86.972 us/op | |
Iteration 6: 85.897 us/op | |
Iteration 7: 94.560 us/op | |
Iteration 8: 92.108 us/op | |
Iteration 9: 87.421 us/op | |
Iteration 10: 87.497 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
88.922 ±(99.9%) 4.075 us/op [Average] | |
(min, avg, max) = (85.897, 88.922, 94.560), stdev = 2.695 | |
CI (99.9%): [84.847, 92.997] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = INT, unique = false) | |
# Run progress: 66.67% complete, ETA 00:02:22 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 153.842 us/op | |
# Warmup Iteration 2: 138.102 us/op | |
# Warmup Iteration 3: 139.057 us/op | |
# Warmup Iteration 4: 138.599 us/op | |
# Warmup Iteration 5: 137.627 us/op | |
# Warmup Iteration 6: 138.203 us/op | |
# Warmup Iteration 7: 138.206 us/op | |
# Warmup Iteration 8: 137.871 us/op | |
# Warmup Iteration 9: 137.348 us/op | |
# Warmup Iteration 10: 137.152 us/op | |
Iteration 1: 137.830 us/op | |
Iteration 2: 137.155 us/op | |
Iteration 3: 137.335 us/op | |
Iteration 4: 137.235 us/op | |
Iteration 5: 137.182 us/op | |
Iteration 6: 137.319 us/op | |
Iteration 7: 138.015 us/op | |
Iteration 8: 138.939 us/op | |
Iteration 9: 137.156 us/op | |
Iteration 10: 139.497 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
137.766 ±(99.9%) 1.254 us/op [Average] | |
(min, avg, max) = (137.155, 137.766, 139.497), stdev = 0.829 | |
CI (99.9%): [136.513, 139.020] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BIGINT, unique = false) | |
# Run progress: 71.43% complete, ETA 00:02:02 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 182.663 us/op | |
# Warmup Iteration 2: 161.966 us/op | |
# Warmup Iteration 3: 158.555 us/op | |
# Warmup Iteration 4: 159.082 us/op | |
# Warmup Iteration 5: 156.475 us/op | |
# Warmup Iteration 6: 155.441 us/op | |
# Warmup Iteration 7: 155.956 us/op | |
# Warmup Iteration 8: 156.337 us/op | |
# Warmup Iteration 9: 157.027 us/op | |
# Warmup Iteration 10: 157.201 us/op | |
Iteration 1: 156.265 us/op | |
Iteration 2: 157.959 us/op | |
Iteration 3: 157.115 us/op | |
Iteration 4: 156.423 us/op | |
Iteration 5: 156.906 us/op | |
Iteration 6: 159.341 us/op | |
Iteration 7: 157.586 us/op | |
Iteration 8: 156.454 us/op | |
Iteration 9: 157.885 us/op | |
Iteration 10: 156.857 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
157.279 ±(99.9%) 1.422 us/op [Average] | |
(min, avg, max) = (156.265, 157.279, 159.341), stdev = 0.940 | |
CI (99.9%): [155.857, 158.701] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BIGDECIMAL, unique = false) | |
# Run progress: 76.19% complete, ETA 00:01:41 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 395.877 us/op | |
# Warmup Iteration 2: 359.400 us/op | |
# Warmup Iteration 3: 358.572 us/op | |
# Warmup Iteration 4: 362.453 us/op | |
# Warmup Iteration 5: 355.870 us/op | |
# Warmup Iteration 6: 354.721 us/op | |
# Warmup Iteration 7: 355.773 us/op | |
# Warmup Iteration 8: 357.611 us/op | |
# Warmup Iteration 9: 359.812 us/op | |
# Warmup Iteration 10: 362.086 us/op | |
Iteration 1: 358.998 us/op | |
Iteration 2: 355.178 us/op | |
Iteration 3: 365.435 us/op | |
Iteration 4: 356.455 us/op | |
Iteration 5: 358.877 us/op | |
Iteration 6: 355.965 us/op | |
Iteration 7: 353.355 us/op | |
Iteration 8: 353.478 us/op | |
Iteration 9: 354.475 us/op | |
Iteration 10: 353.396 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
356.561 ±(99.9%) 5.668 us/op [Average] | |
(min, avg, max) = (353.355, 356.561, 365.435), stdev = 3.749 | |
CI (99.9%): [350.894, 362.229] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = STRING, unique = false) | |
# Run progress: 80.95% complete, ETA 00:01:21 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 168.731 us/op | |
# Warmup Iteration 2: 153.836 us/op | |
# Warmup Iteration 3: 152.321 us/op | |
# Warmup Iteration 4: 151.075 us/op | |
# Warmup Iteration 5: 152.436 us/op | |
# Warmup Iteration 6: 151.835 us/op | |
# Warmup Iteration 7: 151.454 us/op | |
# Warmup Iteration 8: 150.990 us/op | |
# Warmup Iteration 9: 150.626 us/op | |
# Warmup Iteration 10: 150.333 us/op | |
Iteration 1: 150.399 us/op | |
Iteration 2: 150.940 us/op | |
Iteration 3: 152.191 us/op | |
Iteration 4: 152.124 us/op | |
Iteration 5: 152.777 us/op | |
Iteration 6: 153.958 us/op | |
Iteration 7: 157.924 us/op | |
Iteration 8: 149.870 us/op | |
Iteration 9: 149.283 us/op | |
Iteration 10: 150.893 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
152.036 ±(99.9%) 3.785 us/op [Average] | |
(min, avg, max) = (149.283, 152.036, 157.924), stdev = 2.503 | |
CI (99.9%): [148.251, 155.820] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = TIMESTAMP, unique = false) | |
# Run progress: 85.71% complete, ETA 00:01:01 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: TimeZone.getDefault().getDisplayName() = Australian Central Standard Time (South Australia) | |
546.492 us/op | |
# Warmup Iteration 2: 484.515 us/op | |
# Warmup Iteration 3: 480.680 us/op | |
# Warmup Iteration 4: 472.448 us/op | |
# Warmup Iteration 5: 473.300 us/op | |
# Warmup Iteration 6: 479.567 us/op | |
# Warmup Iteration 7: 477.054 us/op | |
# Warmup Iteration 8: 475.858 us/op | |
# Warmup Iteration 9: 483.017 us/op | |
# Warmup Iteration 10: 476.865 us/op | |
Iteration 1: 475.958 us/op | |
Iteration 2: 479.387 us/op | |
Iteration 3: 474.375 us/op | |
Iteration 4: 480.643 us/op | |
Iteration 5: 477.201 us/op | |
Iteration 6: 479.368 us/op | |
Iteration 7: 477.722 us/op | |
Iteration 8: 476.366 us/op | |
Iteration 9: 472.881 us/op | |
Iteration 10: 477.272 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
477.117 ±(99.9%) 3.578 us/op [Average] | |
(min, avg, max) = (472.881, 477.117, 480.643), stdev = 2.367 | |
CI (99.9%): [473.539, 480.696] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = TIMESTAMPTZ, unique = false) | |
# Run progress: 90.48% complete, ETA 00:00:40 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 195.731 us/op | |
# Warmup Iteration 2: 169.282 us/op | |
# Warmup Iteration 3: 182.584 us/op | |
# Warmup Iteration 4: 172.991 us/op | |
# Warmup Iteration 5: 170.419 us/op | |
# Warmup Iteration 6: 171.586 us/op | |
# Warmup Iteration 7: 167.090 us/op | |
# Warmup Iteration 8: 166.846 us/op | |
# Warmup Iteration 9: 167.381 us/op | |
# Warmup Iteration 10: 169.041 us/op | |
Iteration 1: 175.987 us/op | |
Iteration 2: 172.541 us/op | |
Iteration 3: 168.795 us/op | |
Iteration 4: 168.672 us/op | |
Iteration 5: 169.749 us/op | |
Iteration 6: 168.273 us/op | |
Iteration 7: 168.957 us/op | |
Iteration 8: 167.385 us/op | |
Iteration 9: 170.582 us/op | |
Iteration 10: 169.126 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
170.007 ±(99.9%) 3.825 us/op [Average] | |
(min, avg, max) = (167.385, 170.007, 175.987), stdev = 2.530 | |
CI (99.9%): [166.182, 173.831] (assumes normal distribution) | |
# JMH 1.17.4 (released 251 days ago, please consider updating!) | |
# VM version: JDK 1.8.0_131, VM 25.131-b11 | |
# VM invoker: /Library/Java/JavaVirtualMachines/jdk1.8.0_131.jdk/Contents/Home/jre/bin/java | |
# VM options: -Xmx128m -Duser=pgjdbc -Ddatabase=pgjdbc -Dpassword=pgjdbc | |
# Warmup: 10 iterations, 1 s each | |
# Measurement: 10 iterations, 1 s each | |
# Timeout: 10 min per iteration | |
# Threads: 1 thread, will synchronize iterations | |
# Benchmark mode: Average time, time/op | |
# Benchmark: org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch | |
# Parameters: (columnIndexType = NAME, getter = BEST, ncols = 5, nrows = 100, reuseStatement = false, type = BOOL, unique = false) | |
# Run progress: 95.24% complete, ETA 00:00:20 | |
# Fork: 1 of 1 | |
# Warmup Iteration 1: 145.461 us/op | |
# Warmup Iteration 2: 129.455 us/op | |
# Warmup Iteration 3: 127.699 us/op | |
# Warmup Iteration 4: 130.732 us/op | |
# Warmup Iteration 5: 130.985 us/op | |
# Warmup Iteration 6: 130.133 us/op | |
# Warmup Iteration 7: 128.701 us/op | |
# Warmup Iteration 8: 128.422 us/op | |
# Warmup Iteration 9: 129.255 us/op | |
# Warmup Iteration 10: 130.966 us/op | |
Iteration 1: 129.839 us/op | |
Iteration 2: 130.856 us/op | |
Iteration 3: 129.528 us/op | |
Iteration 4: 129.651 us/op | |
Iteration 5: 128.957 us/op | |
Iteration 6: 129.255 us/op | |
Iteration 7: 129.233 us/op | |
Iteration 8: 128.821 us/op | |
Iteration 9: 131.473 us/op | |
Iteration 10: 134.945 us/op | |
Result "org.postgresql.benchmark.statement.ProcessResultSet.bindExecuteFetch": | |
130.256 ±(99.9%) 2.792 us/op [Average] | |
(min, avg, max) = (128.821, 130.256, 134.945), stdev = 1.847 | |
CI (99.9%): [127.464, 133.048] (assumes normal distribution) | |
# Run complete. Total time: 00:07:08 | |
Benchmark (columnIndexType) (getter) (ncols) (nrows) (reuseStatement) (type) (unique) Mode Cnt Score Error Units | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false INT false avgt 10 41.970 ± 0.604 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BIGINT false avgt 10 43.498 ± 1.001 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BIGDECIMAL false avgt 10 45.389 ± 0.271 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false STRING false avgt 10 42.703 ± 0.668 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false TIMESTAMP false avgt 10 50.749 ± 1.825 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false TIMESTAMPTZ false avgt 10 46.347 ± 1.048 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 1 false BOOL false avgt 10 41.699 ± 0.245 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false INT false avgt 10 91.209 ± 1.168 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BIGINT false avgt 10 99.798 ± 0.422 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BIGDECIMAL false avgt 10 197.957 ± 0.735 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false STRING false avgt 10 99.222 ± 2.512 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false TIMESTAMP false avgt 10 256.735 ± 4.912 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false TIMESTAMPTZ false avgt 10 107.258 ± 2.014 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 50 false BOOL false avgt 10 88.922 ± 4.075 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false INT false avgt 10 137.766 ± 1.254 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BIGINT false avgt 10 157.279 ± 1.422 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BIGDECIMAL false avgt 10 356.561 ± 5.668 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false STRING false avgt 10 152.036 ± 3.785 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false TIMESTAMP false avgt 10 477.117 ± 3.578 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false TIMESTAMPTZ false avgt 10 170.007 ± 3.825 us/op | |
ProcessResultSet.bindExecuteFetch NAME BEST 5 100 false BOOL false avgt 10 130.256 ± 2.792 us/op |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# command to run | |
java -jar ubenchmark/target/benchmarks.jar ProcessResultSet |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment