Ideriha, Takeshi wrote
> 2) benchmarked 3 times for each conditions and got the average result of
> TPS.
>                                      |master branch | prototype      |
> proto/master (%)
>   
> ------------------------------------------------------------------------------------
>    pgbench -c48 -T60 -Msimple -S   | 131297      |130541         |101%
>    pgbench -c48 -T60 -Msimple      | 4956        |4965           |95%
>    pgbench -c48 -T60 -Mprepared -S |129688       |132538         |97%
>    pgbench -c48 -T60 -Mprepared    |5113         |4615           |84%
> 
> 
> 001_global_meta_cache.patch (6K)
> <http://www.postgresql-archive.org/attachment/6026686/0/001_global_meta_cache.patch>


Hello,
Apologies for question. I thought I would just double check percentages that
have been presented.
Is the percentage calculation correct?
as #1 and #3 look inverted to me (say lower when should be higher and vice
versa), and 
#2 and #4 look incorrect generally (percentages look much larger than they
should be based on numbers.

I.e. Msimple -S the protype had slightly worse tps performance (130541)
versus Master (131297). I would expect the percentage to be e.g. 99% not
101%

But I may be misunderstanding something :)

Also, Msimple is 4956 master versus 4965 prototype. Just 9 tps change. A
very slight improvement in tps. but the percentage provided is 95%. I would
expect it to be just over 100%?
Again, maybe im not understanding, and hoping it is just my error :)



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Reply via email to