Search Postgresql Archives

What constitutes "reproducible" numbers from pgbench?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello list,
 
Exactly what constitutes „reproducible“ values from pgbench?  I keep getting a range between 340 tps and 440 tps or something like that using the same command line on the same machine.  Is that reproducible enough?
 
The docs state that one should verify that the numbers are reproducible, so I repeat any test run ten times before believing the results.  I’ve tried increasing the test duration (-T) from one minute to five minutes, then turning off autovacuum (in postgresql.conf) as recommended by the docs, but the range of results is not getting any narrower.  So what does “reproducible” mean as applied to pgbench?
 
Obviously I could be doing something wrong, such as missing some vital configuration option…
 
Thanks in advance for any insights.
 
Cheers,
Holger Friedrich
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux