pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Kevin Grittner <kgrittn@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: what to revert
Date: Sun, 15 May 2016 22:06:28 +0200
Message-ID: <abc7b880-ebd3-39a8-0a25-51dbd7d67f18@2ndquadrant.com> (raw )
In-Reply-To: <CACjxUsMMew5_VefF09=Nz2D+6iUYvo=uhesLhZ5L+3WRf8v7Rg@mail.gmail.com >
References: <CA+TgmoYOWTtBQEL+Bv=w93bvUjbXSUw3uGnp+R29dduZ==8K0Q@mail.gmail.com >
<CACjxUsOuf_a6KMsFBNtt8Tn8y7qNLE2Wcb9BQeRFdHD6oAKp3g@mail.gmail.com >
<20160503162209.ufuezlkovbrdrayp@alap3.anarazel.de >
<CACjxUsPb63TqU1uBc6zW5fsFynUB=BZ8NbFp6E=jK9qA7twibg@mail.gmail.com >
<20160503174104.tk7oz4akwbeqsmuq@alap3.anarazel.de >
<c7ad0f06-52c6-6284-c3a0-251807be9d3f@2ndquadrant.com >
<20160503224241.rwtxrhgmprzqxhlv@alap3.anarazel.de >
<eb3d6105-7165-fe71-f753-0a95281c3c19@2ndquadrant.com >
<e17a7535-09b8-2273-0f7c-2d368390b0ed@2ndquadrant.com >
<CACjxUsPgmm+LLG1+3d56EhCD8yEKP_b14zHGFOUpJp0Qx-J2pw@mail.gmail.com >
<c7ef10b9-276e-71bd-a76b-b5782d8d7033@2ndquadrant.com >
<CACjxUsMMew5_VefF09=Nz2D+6iUYvo=uhesLhZ5L+3WRf8v7Rg@mail.gmail.com >
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Hi,
I've repeated the tests with the read-only workload, with the number of
runs for each combination increased to 20 (so 4x higher compared to the
initial runs). Also, this time I've collected sar statistics so that
there's a chance of investigating the sudden tps drops observed in some
of the cases. All the tests were on 8ee29a19, i.e. the commit that
stamped 9.6beta1.
Attached is an ODS spreadsheet with the basic data, the full logs are
available in the same google drive folder as before (old_snapshot2.tgz):
https://drive.google.com/open?id=0BzigUP2Fn0XbR1dyOFA3dUxRaUU
The results (average tps) for the three scales (100, 3000 and 100000)
look like this (also see the three charts attached):
scale dataset 1 16 32 64 128
-------------------------------------------------------------------
100 disabled 18810 238813 390341 532965 452003
100 immediate 18792 229819 360048 141869 175624
100 revert 18458 235814 390306 524320 450595
scale dataset 1 16 32 64 128
-------------------------------------------------------------------
3000 disabled 17266 221723 366303 497338 413649
3000 immediate 17277 216554 342688 143374 256825
3000 revert 16893 220532 363965 494249 402798
scale dataset 1 16 32 64 128
-------------------------------------------------------------------
10000 disabled 14383 174992 270889 389629 344499
10000 immediate 14548 172316 257042 173671 200582
10000 revert 14109 162818 245688 370565 332799
And as a percentage vs. the "revert" case:
scale dataset 1 16 32 64 128
---------------------------------------------------------------
100 disabled 101.91% 101.27% 100.01% 101.65% 100.31%
100 immediate 101.81% 97.46% 92.25% 27.06% 38.98%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
3000 disabled 102.21% 100.54% 100.64% 100.62% 102.69%
3000 immediate 102.27% 98.20% 94.15% 29.01% 63.76%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
10000 disabled 101.94% 107.48% 110.26% 105.14% 103.52%
10000 immediate 103.11% 105.83% 104.62% 46.87% 60.27%
I do agree Noah is right that the small (~1-2%) differences may be
simply due to binary layout changes - I haven't taken any steps to
mitigate the influence of that.
The larger differences are however unlikely to be caused by this, I
guess. I mean, the significant performance drop with "immediate" config
and higher client counts is still there, and it's quite massive.
The strange speedup with the feature "disabled" (which gains up to ~10%
compared to the "revert" case with 32 clients) is also still there. I
find that a bit strange, not sure what's the cause here.
Overall, I think this shows that there seems to be no performance
penalty with "disabled" vs. "reverted" - i.e. even with the least
favorable (100% read-only) workload.
Let's see the impact of the patch on variability of results. First, the
(MAX-MIN)/MAX metric:
scale dataset 1 16 32 64 128
---------------------------------------------------------------
100 disabled 9.55% 3.18% 2.84% 4.16% 9.61%
immediate 4.92% 10.96% 4.39% 3.32% 58.95%
revert 4.43% 3.61% 3.01% 13.93% 10.25%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
3000 disabled 13.29% 4.19% 4.52% 9.06% 23.59%
immediate 7.86% 5.93% 3.15% 7.64% 50.41%
revert 12.34% 7.50% 3.99% 10.17% 16.95%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
10000 disabled 9.19% 17.21% 8.85% 8.01% 26.40%
immediate 7.74% 8.29% 8.53% 38.64% 46.09%
revert 4.42% 4.98% 6.58% 12.42% 18.68%
or as a STDDEV/AVERAGE:
scale dataset 1 16 32 64 128
---------------------------------------------------------------
100 disabled 2.34% 0.74% 1.00% 1.20% 2.65%
immediate 1.51% 2.65% 1.11% 0.69% 34.35%
revert 1.47% 0.94% 0.78% 3.22% 2.73%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
3000 disabled 2.93% 1.19% 1.06% 2.04% 6.99%
immediate 2.31% 1.34% 0.88% 1.72% 18.15%
revert 2.81% 1.51% 0.96% 2.64% 4.85%
scale dataset 1 16 32 64 128
---------------------------------------------------------------
10000 disabled 3.56% 4.51% 2.62% 1.73% 7.56%
immediate 2.53% 2.36% 2.82% 15.61% 18.20%
revert 1.41% 1.45% 1.69% 3.16% 6.39%
Whatever the metric is, I think it's fairly clear the patch makes the
results way more volatile - particularly with the "immediate" case and
higher client counts.
I'm not sure whether that's problem with NUMA or one of the bugs in the
kernel scheduler. But even if it is, we should not ignore that as it
will take a long time before most users migrate to fixed kernels.
AFAIK the system is not using autogroups, and I've rebooted it before
repeating the tests to make sure none of the cores were turned off
(e.g. during some experiments with hyper-threading or something). That
should eliminate the related scheduling bugs.
The end of the "numactl --hardware" output looks like this:
node distances:
node 0 1 2 3
0: 10 21 30 21
1: 21 10 21 30
2: 30 21 10 21
3: 21 30 21 10
Which I think means that there may be up to two hops, making the system
vulnerable to the "Scheduling Group Construction" bug. But it seems a
bit strange that it would only affect one of the cases ("immediate").
What I plan to do next, over the next week:
1) Wait for the second run of "immediate" to complete (should happen in
a few hours)
2) Do tests with other workloads (mostly read-only, read-write).
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Attachments:
old_snap2.csv (text/csv, 22.9K) download
dataset,scale,clients,run,tps
immediate,100,1,1,18744
immediate,100,1,2,18797
immediate,100,1,3,18756
immediate,100,1,4,19367
immediate,100,1,5,18596
immediate,100,1,6,18606
immediate,100,1,7,19280
immediate,100,1,8,19073
immediate,100,1,9,18782
immediate,100,1,10,18507
immediate,100,1,11,19032
immediate,100,1,12,18602
immediate,100,1,13,18533
immediate,100,1,14,19322
immediate,100,1,15,18624
immediate,100,1,16,18579
immediate,100,1,17,18414
immediate,100,1,18,18665
immediate,100,1,19,18941
immediate,100,1,20,18614
immediate,100,16,1,231776
immediate,100,16,2,228587
immediate,100,16,3,226357
immediate,100,16,4,233189
immediate,100,16,5,231589
immediate,100,16,6,209941
immediate,100,16,7,229782
immediate,100,16,8,235771
immediate,100,16,9,231690
immediate,100,16,10,227113
immediate,100,16,11,233031
immediate,100,16,12,233651
immediate,100,16,13,233872
immediate,100,16,14,230885
immediate,100,16,15,217494
immediate,100,16,16,233500
immediate,100,16,17,232667
immediate,100,16,18,232683
immediate,100,16,19,231880
immediate,100,16,20,230922
immediate,100,32,1,362066
immediate,100,32,2,359772
immediate,100,32,3,352479
immediate,100,32,4,362321
immediate,100,32,5,363022
immediate,100,32,6,354670
immediate,100,32,7,363521
immediate,100,32,8,364988
immediate,100,32,9,360681
immediate,100,32,10,363225
immediate,100,32,11,362073
immediate,100,32,12,360847
immediate,100,32,13,362411
immediate,100,32,14,362465
immediate,100,32,15,361406
immediate,100,32,16,348969
immediate,100,32,17,357752
immediate,100,32,18,359250
immediate,100,32,19,361244
immediate,100,32,20,357794
immediate,100,64,1,144896
immediate,100,64,2,141988
immediate,100,64,3,140990
immediate,100,64,4,142210
immediate,100,64,5,143083
immediate,100,64,6,142212
immediate,100,64,7,141245
immediate,100,64,8,141298
immediate,100,64,9,141204
immediate,100,64,10,142230
immediate,100,64,11,141699
immediate,100,64,12,140897
immediate,100,64,13,140085
immediate,100,64,14,141244
immediate,100,64,15,141598
immediate,100,64,16,142008
immediate,100,64,17,142324
immediate,100,64,18,141792
immediate,100,64,19,141829
immediate,100,64,20,142545
immediate,100,128,1,155610
immediate,100,128,2,156322
immediate,100,128,3,314536
immediate,100,128,4,145912
immediate,100,128,5,158534
immediate,100,128,6,144403
immediate,100,128,7,141611
immediate,100,128,8,141766
immediate,100,128,9,148427
immediate,100,128,10,148275
immediate,100,128,11,142975
immediate,100,128,12,129121
immediate,100,128,13,279002
immediate,100,128,14,153261
immediate,100,128,15,130124
immediate,100,128,16,265292
immediate,100,128,17,159265
immediate,100,128,18,304750
immediate,100,128,19,147214
immediate,100,128,20,146077
immediate,3000,1,1,16473
immediate,3000,1,2,17643
immediate,3000,1,3,17753
immediate,3000,1,4,17698
immediate,3000,1,5,17818
immediate,3000,1,6,17006
immediate,3000,1,7,17879
immediate,3000,1,8,17849
immediate,3000,1,9,17185
immediate,3000,1,10,17000
immediate,3000,1,11,17286
immediate,3000,1,12,17087
immediate,3000,1,13,17008
immediate,3000,1,14,16713
immediate,3000,1,15,17624
immediate,3000,1,16,17060
immediate,3000,1,17,17129
immediate,3000,1,18,17122
immediate,3000,1,19,17079
immediate,3000,1,20,17126
immediate,3000,16,1,212776
immediate,3000,16,2,214416
immediate,3000,16,3,215916
immediate,3000,16,4,215024
immediate,3000,16,5,215679
immediate,3000,16,6,217402
immediate,3000,16,7,217892
immediate,3000,16,8,218389
immediate,3000,16,9,216811
immediate,3000,16,10,218816
immediate,3000,16,11,222719
immediate,3000,16,12,214962
immediate,3000,16,13,209518
immediate,3000,16,14,212419
immediate,3000,16,15,217543
immediate,3000,16,16,217354
immediate,3000,16,17,217488
immediate,3000,16,18,217403
immediate,3000,16,19,219947
immediate,3000,16,20,218616
immediate,3000,32,1,342606
immediate,3000,32,2,343029
immediate,3000,32,3,336985
immediate,3000,32,4,344955
immediate,3000,32,5,345783
immediate,3000,32,6,341185
immediate,3000,32,7,345813
immediate,3000,32,8,340885
immediate,3000,32,9,340711
immediate,3000,32,10,345905
immediate,3000,32,11,343344
immediate,3000,32,12,342294
immediate,3000,32,13,345158
immediate,3000,32,14,340381
immediate,3000,32,15,347928
immediate,3000,32,16,338945
immediate,3000,32,17,341583
immediate,3000,32,18,346849
immediate,3000,32,19,341535
immediate,3000,32,20,337890
immediate,3000,64,1,143974
immediate,3000,64,2,144542
immediate,3000,64,3,145461
immediate,3000,64,4,142339
immediate,3000,64,5,152097
immediate,3000,64,6,142132
immediate,3000,64,7,140918
immediate,3000,64,8,143976
immediate,3000,64,9,143353
immediate,3000,64,10,143883
immediate,3000,64,11,143694
immediate,3000,64,12,140478
immediate,3000,64,13,141754
immediate,3000,64,14,141912
immediate,3000,64,15,142273
immediate,3000,64,16,142961
immediate,3000,64,17,142305
immediate,3000,64,18,143168
immediate,3000,64,19,145181
immediate,3000,64,20,141075
immediate,3000,128,1,322046
immediate,3000,128,2,309115
immediate,3000,128,3,279130
immediate,3000,128,4,254515
immediate,3000,128,5,159690
immediate,3000,128,6,288893
immediate,3000,128,7,293167
immediate,3000,128,8,228950
immediate,3000,128,9,223815
immediate,3000,128,10,213768
immediate,3000,128,11,223260
immediate,3000,128,12,260246
immediate,3000,128,13,316272
immediate,3000,128,14,290626
immediate,3000,128,15,254196
immediate,3000,128,16,283906
immediate,3000,128,17,173982
immediate,3000,128,18,263554
immediate,3000,128,19,200313
immediate,3000,128,20,297058
immediate,10000,1,1,14891
immediate,10000,1,2,14586
immediate,10000,1,3,14393
immediate,10000,1,4,14353
immediate,10000,1,5,14931
immediate,10000,1,6,13844
immediate,10000,1,7,14448
immediate,10000,1,8,14369
immediate,10000,1,9,14925
immediate,10000,1,10,14310
immediate,10000,1,11,14341
immediate,10000,1,12,14917
immediate,10000,1,13,14910
immediate,10000,1,14,14978
immediate,10000,1,15,14665
immediate,10000,1,16,14804
immediate,10000,1,17,14339
immediate,10000,1,18,13861
immediate,10000,1,19,15005
immediate,10000,1,20,14091
immediate,10000,16,1,171879
immediate,10000,16,2,169327
immediate,10000,16,3,174287
immediate,10000,16,4,170663
immediate,10000,16,5,174077
immediate,10000,16,6,173469
immediate,10000,16,7,166263
immediate,10000,16,8,165228
immediate,10000,16,9,173548
immediate,10000,16,10,175223
immediate,10000,16,11,175372
immediate,10000,16,12,177152
immediate,10000,16,13,168074
immediate,10000,16,14,173712
immediate,10000,16,15,171204
immediate,10000,16,16,176646
immediate,10000,16,17,163247
immediate,10000,16,18,174954
immediate,10000,16,19,178006
immediate,10000,16,20,173997
immediate,10000,32,1,247881
immediate,10000,32,2,264690
immediate,10000,32,3,264071
immediate,10000,32,4,266188
immediate,10000,32,5,249257
immediate,10000,32,6,255475
immediate,10000,32,7,262681
immediate,10000,32,8,254514
immediate,10000,32,9,266302
immediate,10000,32,10,251627
immediate,10000,32,11,251458
immediate,10000,32,12,252785
immediate,10000,32,13,249099
immediate,10000,32,14,253756
immediate,10000,32,15,253525
immediate,10000,32,16,253650
immediate,10000,32,17,271010
immediate,10000,32,18,254878
immediate,10000,32,19,267780
immediate,10000,32,20,250218
immediate,10000,64,1,142920
immediate,10000,64,2,200945
immediate,10000,64,3,150343
immediate,10000,64,4,196043
immediate,10000,64,5,143589
immediate,10000,64,6,164432
immediate,10000,64,7,203877
immediate,10000,64,8,177191
immediate,10000,64,9,153475
immediate,10000,64,10,171651
immediate,10000,64,11,216078
immediate,10000,64,12,144604
immediate,10000,64,13,232922
immediate,10000,64,14,167729
immediate,10000,64,15,151651
immediate,10000,64,16,150686
immediate,10000,64,17,199168
immediate,10000,64,18,181905
immediate,10000,64,19,143241
immediate,10000,64,20,180979
immediate,10000,128,1,192808
immediate,10000,128,2,186051
immediate,10000,128,3,141290
immediate,10000,128,4,258879
immediate,10000,128,5,228983
immediate,10000,128,6,170966
immediate,10000,128,7,184671
immediate,10000,128,8,209011
immediate,10000,128,9,152548
immediate,10000,128,10,154930
immediate,10000,128,11,180949
immediate,10000,128,12,185593
immediate,10000,128,13,246444
immediate,10000,128,14,262092
immediate,10000,128,15,245107
immediate,10000,128,16,201097
immediate,10000,128,17,188155
immediate,10000,128,18,251355
immediate,10000,128,19,190986
immediate,10000,128,20,179721
disabled,100,1,1,18592
disabled,100,1,2,18792
disabled,100,1,3,17714
disabled,100,1,4,18605
disabled,100,1,5,18287
disabled,100,1,6,18702
disabled,100,1,7,18768
disabled,100,1,8,19585
disabled,100,1,9,18699
disabled,100,1,10,19582
disabled,100,1,11,18761
disabled,100,1,12,18599
disabled,100,1,13,18619
disabled,100,1,14,18713
disabled,100,1,15,18632
disabled,100,1,16,19338
disabled,100,1,17,18990
disabled,100,1,18,18966
disabled,100,1,19,18791
disabled,100,1,20,19474
disabled,100,16,1,236683
disabled,100,16,2,238461
disabled,100,16,3,239700
disabled,100,16,4,235698
disabled,100,16,5,238004
disabled,100,16,6,239318
disabled,100,16,7,238817
disabled,100,16,8,239232
disabled,100,16,9,238516
disabled,100,16,10,237933
disabled,100,16,11,234280
disabled,100,16,12,239896
disabled,100,16,13,238987
disabled,100,16,14,239386
disabled,100,16,15,241970
disabled,100,16,16,239943
disabled,100,16,17,240524
disabled,100,16,18,238523
disabled,100,16,19,241318
disabled,100,16,20,239062
disabled,100,32,1,385155
disabled,100,32,2,388092
disabled,100,32,3,386874
disabled,100,32,4,393066
disabled,100,32,5,390049
disabled,100,32,6,392986
disabled,100,32,7,385496
disabled,100,32,8,395130
disabled,100,32,9,393754
disabled,100,32,10,395169
disabled,100,32,11,383956
disabled,100,32,12,394233
disabled,100,32,13,386036
disabled,100,32,14,391315
disabled,100,32,15,386882
disabled,100,32,16,395163
disabled,100,32,17,392475
disabled,100,32,18,393454
disabled,100,32,19,391686
disabled,100,32,20,385857
disabled,100,64,1,542201
disabled,100,64,2,543087
disabled,100,64,3,532585
disabled,100,64,4,530713
disabled,100,64,5,524235
disabled,100,64,6,536666
disabled,100,64,7,537372
disabled,100,64,8,523253
disabled,100,64,9,531679
disabled,100,64,10,537385
disabled,100,64,11,538690
disabled,100,64,12,536453
disabled,100,64,13,532904
disabled,100,64,14,532992
disabled,100,64,15,536988
disabled,100,64,16,528005
disabled,100,64,17,535517
disabled,100,64,18,535594
disabled,100,64,19,522484
disabled,100,64,20,520504
disabled,100,128,1,455406
disabled,100,128,2,438115
disabled,100,128,3,446411
disabled,100,128,4,441763
disabled,100,128,5,444441
disabled,100,128,6,438603
disabled,100,128,7,448837
disabled,100,128,8,465758
disabled,100,128,9,447847
disabled,100,128,10,433760
disabled,100,128,11,453324
disabled,100,128,12,479874
disabled,100,128,13,458494
disabled,100,128,14,456462
disabled,100,128,15,461512
disabled,100,128,16,444655
disabled,100,128,17,459284
disabled,100,128,18,446413
disabled,100,128,19,445232
disabled,100,128,20,473869
disabled,3000,1,1,15687
disabled,3000,1,2,17255
disabled,3000,1,3,17692
disabled,3000,1,4,17365
disabled,3000,1,5,17948
disabled,3000,1,6,18092
disabled,3000,1,7,17410
disabled,3000,1,8,17118
disabled,3000,1,9,17418
disabled,3000,1,10,17119
disabled,3000,1,11,17088
disabled,3000,1,12,17024
disabled,3000,1,13,17166
disabled,3000,1,14,17250
disabled,3000,1,15,17195
disabled,3000,1,16,17081
disabled,3000,1,17,17313
disabled,3000,1,18,18060
disabled,3000,1,19,16836
disabled,3000,1,20,17201
disabled,3000,16,1,225610
disabled,3000,16,2,224421
disabled,3000,16,3,220967
disabled,3000,16,4,225539
disabled,3000,16,5,218980
disabled,3000,16,6,220867
disabled,3000,16,7,220571
disabled,3000,16,8,216324
disabled,3000,16,9,222795
disabled,3000,16,10,216146
disabled,3000,16,11,221634
disabled,3000,16,12,222679
disabled,3000,16,13,223002
disabled,3000,16,14,222168
disabled,3000,16,15,224799
disabled,3000,16,16,221463
disabled,3000,16,17,223229
disabled,3000,16,18,220245
disabled,3000,16,19,219581
disabled,3000,16,20,223434
disabled,3000,32,1,368677
disabled,3000,32,2,366481
disabled,3000,32,3,366691
disabled,3000,32,4,366885
disabled,3000,32,5,369253
disabled,3000,32,6,364956
disabled,3000,32,7,358199
disabled,3000,32,8,367453
disabled,3000,32,9,364629
disabled,3000,32,10,369064
disabled,3000,32,11,375166
disabled,3000,32,12,365323
disabled,3000,32,13,360405
disabled,3000,32,14,367062
disabled,3000,32,15,365126
disabled,3000,32,16,367864
disabled,3000,32,17,363437
disabled,3000,32,18,373025
disabled,3000,32,19,363221
disabled,3000,32,20,363137
disabled,3000,64,1,499226
disabled,3000,64,2,488494
disabled,3000,64,3,497400
disabled,3000,64,4,481718
disabled,3000,64,5,499586
disabled,3000,64,6,503696
disabled,3000,64,7,495225
disabled,3000,64,8,510175
disabled,3000,64,9,464278
disabled,3000,64,10,496530
disabled,3000,64,11,505594
disabled,3000,64,12,497239
disabled,3000,64,13,499180
disabled,3000,64,14,500030
disabled,3000,64,15,501488
disabled,3000,64,16,503758
disabled,3000,64,17,498856
disabled,3000,64,18,510559
disabled,3000,64,19,496518
disabled,3000,64,20,497206
disabled,3000,128,1,505224
disabled,3000,128,2,409648
disabled,3000,128,3,424732
disabled,3000,128,4,410717
disabled,3000,128,5,406792
disabled,3000,128,6,386053
disabled,3000,128,7,405484
disabled,3000,128,8,392739
disabled,3000,128,9,400549
disabled,3000,128,10,409237
disabled,3000,128,11,410614
disabled,3000,128,12,395534
disabled,3000,128,13,394185
disabled,3000,128,14,472739
disabled,3000,128,15,392504
disabled,3000,128,16,392364
disabled,3000,128,17,409516
disabled,3000,128,18,405079
disabled,3000,128,19,438508
disabled,3000,128,20,410756
disabled,10000,1,1,14088
disabled,10000,1,2,14005
disabled,10000,1,3,14688
disabled,10000,1,4,13943
disabled,10000,1,5,14538
disabled,10000,1,6,14602
disabled,10000,1,7,15250
disabled,10000,1,8,13960
disabled,10000,1,9,13897
disabled,10000,1,10,14176
disabled,10000,1,11,14393
disabled,10000,1,12,15279
disabled,10000,1,13,15237
disabled,10000,1,14,14682
disabled,10000,1,15,13875
disabled,10000,1,16,14119
disabled,10000,1,17,13967
disabled,10000,1,18,15165
disabled,10000,1,19,13925
disabled,10000,1,20,13880
disabled,10000,16,1,178774
disabled,10000,16,2,188389
disabled,10000,16,3,179080
disabled,10000,16,4,180138
disabled,10000,16,5,155968
disabled,10000,16,6,177853
disabled,10000,16,7,187550
disabled,10000,16,8,172332
disabled,10000,16,9,168766
disabled,10000,16,10,172885
disabled,10000,16,11,166933
disabled,10000,16,12,180904
disabled,10000,16,13,177926
disabled,10000,16,14,178307
disabled,10000,16,15,172118
disabled,10000,16,16,179353
disabled,10000,16,17,165739
disabled,10000,16,18,177149
disabled,10000,16,19,176010
disabled,10000,16,20,163670
disabled,10000,32,1,276142
disabled,10000,32,2,272141
disabled,10000,32,3,268294
disabled,10000,32,4,276972
disabled,10000,32,5,275087
disabled,10000,32,6,275888
disabled,10000,32,7,269550
disabled,10000,32,8,275640
disabled,10000,32,9,273859
disabled,10000,32,10,269508
disabled,10000,32,11,275743
disabled,10000,32,12,276295
disabled,10000,32,13,275946
disabled,10000,32,14,275203
disabled,10000,32,15,259304
disabled,10000,32,16,252447
disabled,10000,32,17,260283
disabled,10000,32,18,261300
disabled,10000,32,19,276523
disabled,10000,32,20,271665
disabled,10000,64,1,396690
disabled,10000,64,2,388932
disabled,10000,64,3,389169
disabled,10000,64,4,389428
disabled,10000,64,5,393222
disabled,10000,64,6,366857
disabled,10000,64,7,398819
disabled,10000,64,8,395486
disabled,10000,64,9,386405
disabled,10000,64,10,391359
disabled,10000,64,11,388665
disabled,10000,64,12,391024
disabled,10000,64,13,387971
disabled,10000,64,14,387837
disabled,10000,64,15,381582
disabled,10000,64,16,393386
disabled,10000,64,17,393448
disabled,10000,64,18,395741
disabled,10000,64,19,386997
disabled,10000,64,20,389553
disabled,10000,128,1,365679
disabled,10000,128,2,296714
disabled,10000,128,3,352082
disabled,10000,128,4,361361
disabled,10000,128,5,355782
disabled,10000,128,6,328885
disabled,10000,128,7,359092
disabled,10000,128,8,372994
disabled,10000,128,9,352551
disabled,10000,128,10,357178
disabled,10000,128,11,330671
disabled,10000,128,12,274513
disabled,10000,128,13,351946
disabled,10000,128,14,361830
disabled,10000,128,15,304464
disabled,10000,128,16,348166
disabled,10000,128,17,332246
disabled,10000,128,18,368668
disabled,10000,128,19,363153
disabled,10000,128,20,352015
revert,100,1,1,18094
revert,100,1,2,18768
revert,100,1,3,18302
revert,100,1,4,18837
revert,100,1,5,18023
revert,100,1,6,18429
revert,100,1,7,18654
revert,100,1,8,18489
revert,100,1,9,18728
revert,100,1,10,18510
revert,100,1,11,18447
revert,100,1,12,18147
revert,100,1,13,18582
revert,100,1,14,18597
revert,100,1,15,18076
revert,100,1,16,18594
revert,100,1,17,18003
revert,100,1,18,18825
revert,100,1,19,18673
revert,100,1,20,18380
revert,100,16,1,237025
revert,100,16,2,235112
revert,100,16,3,237702
revert,100,16,4,236851
revert,100,16,5,234194
revert,100,16,6,237677
revert,100,16,7,230287
revert,100,16,8,238206
revert,100,16,9,236673
revert,100,16,10,236782
revert,100,16,11,237917
revert,100,16,12,235372
revert,100,16,13,236062
revert,100,16,14,232372
revert,100,16,15,236468
revert,100,16,16,236540
revert,100,16,17,238902
revert,100,16,18,232565
revert,100,16,19,236042
revert,100,16,20,233523
revert,100,32,1,388048
revert,100,32,2,390576
revert,100,32,3,393200
revert,100,32,4,390246
revert,100,32,5,387890
revert,100,32,6,393216
revert,100,32,7,393404
revert,100,32,8,392870
revert,100,32,9,392535
revert,100,32,10,386547
revert,100,32,11,391862
revert,100,32,12,389461
revert,100,32,13,391989
revert,100,32,14,388508
revert,100,32,15,392445
revert,100,32,16,392220
revert,100,32,17,387756
revert,100,32,18,388570
revert,100,32,19,393217
revert,100,32,20,381560
revert,100,64,1,530165
revert,100,64,2,531164
revert,100,64,3,536144
revert,100,64,4,514357
revert,100,64,5,534983
revert,100,64,6,464538
revert,100,64,7,532959
revert,100,64,8,538328
revert,100,64,9,531976
revert,100,64,10,500399
revert,100,64,11,515560
revert,100,64,12,524629
revert,100,64,13,530239
revert,100,64,14,519337
revert,100,64,15,534016
revert,100,64,16,539724
revert,100,64,17,527946
revert,100,64,18,530032
revert,100,64,19,526737
revert,100,64,20,523160
revert,100,128,1,431253
revert,100,128,2,450849
revert,100,128,3,480510
revert,100,128,4,468862
revert,100,128,5,454590
revert,100,128,6,459790
revert,100,128,7,449970
revert,100,128,8,455340
revert,100,128,9,465855
revert,100,128,10,448843
revert,100,128,11,442032
revert,100,128,12,449990
revert,100,128,13,437311
revert,100,128,14,444319
revert,100,128,15,440834
revert,100,128,16,442873
revert,100,128,17,445163
revert,100,128,18,464495
revert,100,128,19,439173
revert,100,128,20,439861
revert,3000,1,1,15386
revert,3000,1,2,17417
revert,3000,1,3,17250
revert,3000,1,4,16925
revert,3000,1,5,16482
revert,3000,1,6,16824
revert,3000,1,7,16583
revert,3000,1,8,16900
revert,3000,1,9,16847
revert,3000,1,10,16833
revert,3000,1,11,17182
revert,3000,1,12,16838
revert,3000,1,13,17531
revert,3000,1,14,16756
revert,3000,1,15,16890
revert,3000,1,16,17551
revert,3000,1,17,17417
revert,3000,1,18,16854
revert,3000,1,19,16557
revert,3000,1,20,16837
revert,3000,16,1,221198
revert,3000,16,2,220141
revert,3000,16,3,207571
revert,3000,16,4,220227
revert,3000,16,5,220166
revert,3000,16,6,221323
revert,3000,16,7,222302
revert,3000,16,8,219928
revert,3000,16,9,223927
revert,3000,16,10,221498
revert,3000,16,11,224392
revert,3000,16,12,221443
revert,3000,16,13,221931
revert,3000,16,14,219356
revert,3000,16,15,220220
revert,3000,16,16,221134
revert,3000,16,17,221056
revert,3000,16,18,222538
revert,3000,16,19,219504
revert,3000,16,20,220778
revert,3000,32,1,364610
revert,3000,32,2,361513
revert,3000,32,3,368657
revert,3000,32,4,360898
revert,3000,32,5,367339
revert,3000,32,6,362616
revert,3000,32,7,365660
revert,3000,32,8,365100
revert,3000,32,9,362771
revert,3000,32,10,363400
revert,3000,32,11,364463
revert,3000,32,12,370339
revert,3000,32,13,363147
revert,3000,32,14,360843
revert,3000,32,15,364420
revert,3000,32,16,355580
revert,3000,32,17,362651
revert,3000,32,18,370332
revert,3000,32,19,364242
revert,3000,32,20,360713
revert,3000,64,1,497437
revert,3000,64,2,502347
revert,3000,64,3,494153
revert,3000,64,4,494713
revert,3000,64,5,479844
revert,3000,64,6,510529
revert,3000,64,7,498070
revert,3000,64,8,469688
revert,3000,64,9,491323
revert,3000,64,10,482407
revert,3000,64,11,500462
revert,3000,64,12,504017
revert,3000,64,13,500740
revert,3000,64,14,509100
revert,3000,64,15,505099
revert,3000,64,16,494512
revert,3000,64,17,505833
revert,3000,64,18,494204
revert,3000,64,19,458603
revert,3000,64,20,491904
revert,3000,128,1,377185
revert,3000,128,2,406099
revert,3000,128,3,395552
revert,3000,128,4,387955
revert,3000,128,5,439518
revert,3000,128,6,398637
revert,3000,128,7,398971
revert,3000,128,8,387660
revert,3000,128,9,393833
revert,3000,128,10,395416
revert,3000,128,11,406874
revert,3000,128,12,394350
revert,3000,128,13,435258
revert,3000,128,14,381744
revert,3000,128,15,412732
revert,3000,128,16,405381
revert,3000,128,17,454145
revert,3000,128,18,389176
revert,3000,128,19,399800
revert,3000,128,20,395666
revert,10000,1,1,14292
revert,10000,1,2,14271
revert,10000,1,3,14148
revert,10000,1,4,14161
revert,10000,1,5,13873
revert,10000,1,6,14142
revert,10000,1,7,14161
revert,10000,1,8,14315
revert,10000,1,9,13946
revert,10000,1,10,14267
revert,10000,1,11,13805
revert,10000,1,12,14191
revert,10000,1,13,14336
revert,10000,1,14,13703
revert,10000,1,15,13840
revert,10000,1,16,14337
revert,10000,1,17,14167
revert,10000,1,18,13828
revert,10000,1,19,14194
revert,10000,1,20,14203
revert,10000,16,1,164692
revert,10000,16,2,163342
revert,10000,16,3,159233
revert,10000,16,4,163477
revert,10000,16,5,163248
revert,10000,16,6,163181
revert,10000,16,7,161203
revert,10000,16,8,164004
revert,10000,16,9,164512
revert,10000,16,10,160731
revert,10000,16,11,158315
revert,10000,16,12,161087
revert,10000,16,13,166285
revert,10000,16,14,164857
revert,10000,16,15,163423
revert,10000,16,16,165799
revert,10000,16,17,157997
revert,10000,16,18,165080
revert,10000,16,19,162612
revert,10000,16,20,163281
revert,10000,32,1,242073
revert,10000,32,2,248264
revert,10000,32,3,238631
revert,10000,32,4,254283
revert,10000,32,5,248691
revert,10000,32,6,243835
revert,10000,32,7,244744
revert,10000,32,8,244987
revert,10000,32,9,245125
revert,10000,32,10,252762
revert,10000,32,11,249372
revert,10000,32,12,249553
revert,10000,32,13,243804
revert,10000,32,14,245178
revert,10000,32,15,237546
revert,10000,32,16,243166
revert,10000,32,17,247396
revert,10000,32,18,244415
revert,10000,32,19,242658
revert,10000,32,20,247281
revert,10000,64,1,379358
revert,10000,64,2,367736
revert,10000,64,3,382453
revert,10000,64,4,377448
revert,10000,64,5,353859
revert,10000,64,6,375182
revert,10000,64,7,376508
revert,10000,64,8,361835
revert,10000,64,9,388146
revert,10000,64,10,369754
revert,10000,64,11,374060
revert,10000,64,12,359075
revert,10000,64,13,378251
revert,10000,64,14,368065
revert,10000,64,15,370456
revert,10000,64,16,362421
revert,10000,64,17,339920
revert,10000,64,18,384395
revert,10000,64,19,381323
revert,10000,64,20,361057
revert,10000,128,1,314971
revert,10000,128,2,345874
revert,10000,128,3,346666
revert,10000,128,4,354665
revert,10000,128,5,351100
revert,10000,128,6,349619
revert,10000,128,7,355445
revert,10000,128,8,349247
revert,10000,128,9,296526
revert,10000,128,10,313808
revert,10000,128,11,352208
revert,10000,128,12,302161
revert,10000,128,13,321046
revert,10000,128,14,337404
revert,10000,128,15,310911
revert,10000,128,16,364621
revert,10000,128,17,347617
revert,10000,128,18,316102
revert,10000,128,19,306086
revert,10000,128,20,319905
download
pgbench-100.png (image/png, 18.1K) download
view image
pgbench-3000.png (image/png, 17.7K) download
view image
pgbench-10000.png (image/png, 19.7K) download
view image
view thread (56+ messages) latest in thread
Message-ID: <abc7b880-ebd3-39a8-0a25-51dbd7d67f18@2ndquadrant.com>
Permalink: ../abc7b880-ebd3-39a8-0a25-51dbd7d67f18@2ndquadrant.com/
Also on: postgresql.org/message-id/abc7b880-ebd3-39a8-0a25-51dbd7d67f18@2ndquadrant.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tomas.vondra@2ndquadrant.com, kgrittn@gmail.com, andres@anarazel.de
Subject: Re: what to revert
In-Reply-To: <abc7b880-ebd3-39a8-0a25-51dbd7d67f18@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox