On Wed, Dec 12, 2018 at 6:54 AM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
> Hey,
> I installed a new postgres 9.6 on both of my machines. I'm trying to
> measure the differences between the performances in each machine but it
> seems that the results arent accurate.
> I did 2 tests :
riel Cherkassky mailto:mariel.cherkas...@gmail.com>>
*Sent:* Thursday, December 13, 2018 1:45 PM
*To:* Greg Clough mailto:greg.clo...@ihsmarkit.com>>
*Subject:* Re: pgbench results arent accurate
Both of the machines are the only vms in a dedicated e
; to send that last message back to the list, as maybe others will have
>> better ideas.
>>
>>
>>
>> Greg.
>>
>>
>>
>> *From:* Mariel Cherkassky
>> *Sent:* Thursday, December 13, 2018 1:45 PM
>> *To:* Greg Clough
>> *Subject:*
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
