Skip to content

Instantly share code, notes, and snippets.

@tomdcc

tomdcc/benchmarks-master.txt

Created September 26, 2017 05:25
Show Gist options
  • Save tomdcc/3f3398fd44f920287f67a4cc1de501ac to your computer and use it in GitHub Desktop.
Save tomdcc/3f3398fd44f920287f67a4cc1de501ac to your computer and use it in GitHub Desktop.
Download ZIP
PGJDBC master vs tuple class benchmarks for ProcessResultSet
Raw
benchmarks-master.txt
# 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
Raw
benchmarks-tuple-class.txt
# 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
Raw
commands.sh
# 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