If you have not amended any Postgres config parameters, then you'll get
checkpoints approx every 5 min or so. Thus using a Pgbench run time of
5min is going sometimes miss/sometimes hit a checkpoint in progress -
which will hugely impact test results.
I tend to do Pgbench runs of about 2x chec
> I installed a new postgres 9.6 on both of my machines.
Where is your storage? Is it local, or on a SAN? A SAN will definitely have a
cache, so possibly there is another layer of cache that you’re not accounting
for.
Greg Clough.
This e-mail, including acco
