Josh Berkus <josh@agliodbs.com> writes:
>> Um, where are the test runs underlying this spreadsheet? I don't have a
>> whole lot of confidence in looking at full-run average TPM numbers to
>> discern whether transient dropoffs in TPM are significant or not.
> Web in the form of:
> http://khack.osdl.org/stp/#test_number#/
> Where #test_number# is:
> Machine0, no patch:
> 302904
> 302905
> 302906
> Machine0, patch:
> 301901
> 302902
> 302903
> Machine2, no patch:
> 302910
> 302911
> 302912
> Machine2, patch:
> 301907
> 302908
> 302909
Hmm. Eyeballing the NOTPM trace for cases 302912 and 302909, it sure
looks like the post-checkpoint performance recovery is *slower* in
the latter. And why is 302902 visibly slower overall than 302905?
I thought for a bit that you had gotten "patch" vs "no patch" backwards,
but the oprofile results linked to these pages look right: XLogInsert
takes significantly more time in the "no patch" cases.
There's something awfully weird going on here. I was prepared to see
no statistically-significant differences, but not multiple cases that
seem to be going the "wrong direction".
BTW, I'd like to look at 302906, but its [Details] link is broken.
regards, tom lane