public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tomas Vondra <[email protected]>
To: Amit Langote <[email protected]>
To: Junwang Zhao <[email protected]>
Cc: Pavel Stehule <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3
Date: Sun, 1 Mar 2026 13:22:49 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+HiwqF2UHzF0sKCp-F2a-U29rqh_9ZPy=f1h+Fh_=M8efj3pg@mail.gmail.com>
References: <CA+HiwqF4C0ws3cO+z5cLkPuvwnAwkSp7sfvgGj3yQ=Li6KNMqA@mail.gmail.com>
<CA+HiwqGM6nvAV5O+=Nr+BXMPWOma0oeCRVzVP0XiLE8zX5TVAg@mail.gmail.com>
<CA+HiwqGMaovCUgDbGxVGnK0Mrivr+ph3YE2Ws+47-ugyPb4f7g@mail.gmail.com>
<CAFj8pRDaiBe_GOLk_yyYHTtPiDAAaLOM8u1-=Q3ZgXBTH+1igg@mail.gmail.com>
<CA+HiwqGA5Ay_MR0eJEEbt4j6WrVh4F+AasTp8yCbs5aJLOJn6Q@mail.gmail.com>
<CAEG8a3JM=NoqiTK0V6S9FNxZPvy1+C5F7rfafTtPKBVWnunL-g@mail.gmail.com>
<CA+HiwqEyiLCY6MTLbOJXDdLNNQLaURYHvdW797MQgbjEK9od4Q@mail.gmail.com>
<CAEG8a3+VBpwPf1Rm-ECD90whM9b3YnGhux5CVXdsL6khiBfzRQ@mail.gmail.com>
<CA+HiwqF2UHzF0sKCp-F2a-U29rqh_9ZPy=f1h+Fh_=M8efj3pg@mail.gmail.com>
On 2/28/26 08:08, Amit Langote wrote:
> Hi Junwang,
>
> ...
>
> Tomas Vondra also tested with an I/O-intensive workload (dataset
> larger than shared_buffers, combined with his and Peter Geoghegan's
> I/O prefetching patches) and confirmed that the batching + SAOP
> approach helps there too, not just in the CPU-bound / memory-resident
> case. In fact he showed that the patches here don't make a big dent
> when the main bottleneck is I/O as shown in numbers that he shared in
> an off-list email:
>
> master: 161617 ms
> ri-check (0001..0004): 149446 ms (1.08x)
> ri-check + i/o prefetching: 50885 ms (3.2x)
>
> So the RI patches alone only give ~8% here since most time is waiting
> on reads. But the batching gives the prefetch machinery a window of
> upcoming probes to issue readahead against, so the two together yield
> 3.2x.
>
I tested this (with the index prefetching v11 patch), because I wanted
to check if the revised API works fine for other use cases, not just the
regular index scans. Turns out the answer is "yes", the necessary tweaks
to the FK batching patch were pretty minimal, and at the same time it
did help quite a bit for cases bottle-necked on I/O.
FWIW I wonder how difficult would it be to do something like this for
inserts into indexes. It's an orthogonal issue to FK checks (especially
for the CPU-bound cases this thread focuses on), but it's a bit similar
to the I/O-bound case. In fact, I now realize I actually did a PoC for
that in 2023-11 [1], but it went stale ...
benchmarks
----------
Anyway, thinking about the CPU-bound case, I decided to do a bit of
testing on my own. I was wondering about three things:
(a) how does the improvement depend on data distribution
(b) could it cause regressions for small inserts
(c) how sensitive is the batch size
So I devised two simple benchmarks:
1) run-pattern.sh - Inserts batches of values into a table, both the
batch and table can be either random or sequential. It's either 100k or
1M rows, logged or unlogged, etc.
2) run-pgbench.sh - Runs short pgbench inserting data into a table,
similar to (1), but with very few rows - so the timing approach is not
suitable to measure this.
Both scripts run against master, and then patched branch with three
batch sizes (default 64, 16 and 256).
results
-------
The results are very positive - see the attached PDF files comparing the
patched builds to master.
I have not found a single case where the batching causes regressions.
This surprised me a bit, I've expected small regressions for single-row
inserts in the pgbench test, but even that shows a small (~5%) gain.
Even just 2-row inserts show +25% improvement in pgbench throughput.
There are a couple cases where it matches master, I assume that's for
I/O bound cases where the CPU optimizations do not really matter. That's
expected, of course.
I don't see much sensitivity on the batch size. The 256 batches seem to
be a bit slower, but there's little difference between 16 and 64. So I'd
say 64 seems reasonable.
Overall, I think these results looks quite good. I haven't looked at the
code very closely, not beyond adjusting it to work with index prefetch.
[1] https://commitfest.postgresql.org/patch/4622/
--
Tomas Vondra
Attachments:
[text/csv] fk-batch-insert.csv (43.6K, 2-fk-batch-insert.csv)
download | inline:
rows1 rows2 sb wal branch data1 data2 run timing
100000 100000 128MB logged master seq seq 1 220.208
100000 100000 128MB logged master seq rand 1 230.327
100000 100000 128MB logged master seq seq 2 216.138
100000 100000 128MB logged master seq rand 2 242.130
100000 100000 128MB logged master seq seq 3 220.409
100000 100000 128MB logged master seq rand 3 239.814
100000 100000 128MB logged fk-batch-64 seq seq 1 65.597
100000 100000 128MB logged fk-batch-64 seq rand 1 116.721
100000 100000 128MB logged fk-batch-64 seq seq 2 64.987
100000 100000 128MB logged fk-batch-64 seq rand 2 113.707
100000 100000 128MB logged fk-batch-64 seq seq 3 63.281
100000 100000 128MB logged fk-batch-64 seq rand 3 117.920
100000 100000 128MB logged fk-batch-16 seq seq 1 59.925
100000 100000 128MB logged fk-batch-16 seq rand 1 107.105
100000 100000 128MB logged fk-batch-16 seq seq 2 59.353
100000 100000 128MB logged fk-batch-16 seq rand 2 108.106
100000 100000 128MB logged fk-batch-16 seq seq 3 58.043
100000 100000 128MB logged fk-batch-16 seq rand 3 105.151
100000 100000 128MB logged fk-batch-256 seq seq 1 81.792
100000 100000 128MB logged fk-batch-256 seq rand 1 137.863
100000 100000 128MB logged fk-batch-256 seq seq 2 83.760
100000 100000 128MB logged fk-batch-256 seq rand 2 137.815
100000 100000 128MB logged fk-batch-256 seq seq 3 78.765
100000 100000 128MB logged fk-batch-256 seq rand 3 136.390
100000 100000 128MB unlogged master seq seq 1 195.765
100000 100000 128MB unlogged master seq rand 1 204.869
100000 100000 128MB unlogged master seq seq 2 197.258
100000 100000 128MB unlogged master seq rand 2 210.482
100000 100000 128MB unlogged master seq seq 3 197.074
100000 100000 128MB unlogged master seq rand 3 202.599
100000 100000 128MB unlogged fk-batch-64 seq seq 1 44.279
100000 100000 128MB unlogged fk-batch-64 seq rand 1 98.333
100000 100000 128MB unlogged fk-batch-64 seq seq 2 45.074
100000 100000 128MB unlogged fk-batch-64 seq rand 2 96.354
100000 100000 128MB unlogged fk-batch-64 seq seq 3 45.844
100000 100000 128MB unlogged fk-batch-64 seq rand 3 97.205
100000 100000 128MB unlogged fk-batch-16 seq seq 1 43.181
100000 100000 128MB unlogged fk-batch-16 seq rand 1 90.139
100000 100000 128MB unlogged fk-batch-16 seq seq 2 44.550
100000 100000 128MB unlogged fk-batch-16 seq rand 2 87.816
100000 100000 128MB unlogged fk-batch-16 seq seq 3 44.644
100000 100000 128MB unlogged fk-batch-16 seq rand 3 88.174
100000 100000 128MB unlogged fk-batch-256 seq seq 1 62.705
100000 100000 128MB unlogged fk-batch-256 seq rand 1 123.117
100000 100000 128MB unlogged fk-batch-256 seq seq 2 65.952
100000 100000 128MB unlogged fk-batch-256 seq rand 2 117.822
100000 100000 128MB unlogged fk-batch-256 seq seq 3 64.540
100000 100000 128MB unlogged fk-batch-256 seq rand 3 118.338
100000 100000 8GB logged master seq seq 1 215.257
100000 100000 8GB logged master seq rand 1 221.556
100000 100000 8GB logged master seq seq 2 211.919
100000 100000 8GB logged master seq rand 2 224.947
100000 100000 8GB logged master seq seq 3 215.954
100000 100000 8GB logged master seq rand 3 226.042
100000 100000 8GB logged fk-batch-64 seq seq 1 62.537
100000 100000 8GB logged fk-batch-64 seq rand 1 114.810
100000 100000 8GB logged fk-batch-64 seq seq 2 62.454
100000 100000 8GB logged fk-batch-64 seq rand 2 118.104
100000 100000 8GB logged fk-batch-64 seq seq 3 60.188
100000 100000 8GB logged fk-batch-64 seq rand 3 117.201
100000 100000 8GB logged fk-batch-16 seq seq 1 56.982
100000 100000 8GB logged fk-batch-16 seq rand 1 106.079
100000 100000 8GB logged fk-batch-16 seq seq 2 58.727
100000 100000 8GB logged fk-batch-16 seq rand 2 109.677
100000 100000 8GB logged fk-batch-16 seq seq 3 59.712
100000 100000 8GB logged fk-batch-16 seq rand 3 105.327
100000 100000 8GB logged fk-batch-256 seq seq 1 81.495
100000 100000 8GB logged fk-batch-256 seq rand 1 133.608
100000 100000 8GB logged fk-batch-256 seq seq 2 88.003
100000 100000 8GB logged fk-batch-256 seq rand 2 130.541
100000 100000 8GB logged fk-batch-256 seq seq 3 82.641
100000 100000 8GB logged fk-batch-256 seq rand 3 134.880
100000 100000 8GB unlogged master seq seq 1 201.073
100000 100000 8GB unlogged master seq rand 1 208.689
100000 100000 8GB unlogged master seq seq 2 199.018
100000 100000 8GB unlogged master seq rand 2 211.202
100000 100000 8GB unlogged master seq seq 3 196.167
100000 100000 8GB unlogged master seq rand 3 215.719
100000 100000 8GB unlogged fk-batch-64 seq seq 1 45.802
100000 100000 8GB unlogged fk-batch-64 seq rand 1 96.572
100000 100000 8GB unlogged fk-batch-64 seq seq 2 47.638
100000 100000 8GB unlogged fk-batch-64 seq rand 2 96.651
100000 100000 8GB unlogged fk-batch-64 seq seq 3 48.230
100000 100000 8GB unlogged fk-batch-64 seq rand 3 96.567
100000 100000 8GB unlogged fk-batch-16 seq seq 1 42.940
100000 100000 8GB unlogged fk-batch-16 seq rand 1 92.349
100000 100000 8GB unlogged fk-batch-16 seq seq 2 45.853
100000 100000 8GB unlogged fk-batch-16 seq rand 2 87.993
100000 100000 8GB unlogged fk-batch-16 seq seq 3 46.353
100000 100000 8GB unlogged fk-batch-16 seq rand 3 87.716
100000 100000 8GB unlogged fk-batch-256 seq seq 1 64.729
100000 100000 8GB unlogged fk-batch-256 seq rand 1 121.601
100000 100000 8GB unlogged fk-batch-256 seq seq 2 68.567
100000 100000 8GB unlogged fk-batch-256 seq rand 2 124.980
100000 100000 8GB unlogged fk-batch-256 seq seq 3 67.559
100000 100000 8GB unlogged fk-batch-256 seq rand 3 124.117
100000 100000 128MB logged master rand seq 1 218.741
100000 100000 128MB logged master rand rand 1 229.139
100000 100000 128MB logged master rand seq 2 222.343
100000 100000 128MB logged master rand rand 2 228.151
100000 100000 128MB logged master rand seq 3 218.623
100000 100000 128MB logged master rand rand 3 225.962
100000 100000 128MB logged fk-batch-64 rand seq 1 68.649
100000 100000 128MB logged fk-batch-64 rand rand 1 120.123
100000 100000 128MB logged fk-batch-64 rand seq 2 68.027
100000 100000 128MB logged fk-batch-64 rand rand 2 113.859
100000 100000 128MB logged fk-batch-64 rand seq 3 73.888
100000 100000 128MB logged fk-batch-64 rand rand 3 112.968
100000 100000 128MB logged fk-batch-16 rand seq 1 72.368
100000 100000 128MB logged fk-batch-16 rand rand 1 106.640
100000 100000 128MB logged fk-batch-16 rand seq 2 65.078
100000 100000 128MB logged fk-batch-16 rand rand 2 105.328
100000 100000 128MB logged fk-batch-16 rand seq 3 68.277
100000 100000 128MB logged fk-batch-16 rand rand 3 104.093
100000 100000 128MB logged fk-batch-256 rand seq 1 88.440
100000 100000 128MB logged fk-batch-256 rand rand 1 141.935
100000 100000 128MB logged fk-batch-256 rand seq 2 86.163
100000 100000 128MB logged fk-batch-256 rand rand 2 134.766
100000 100000 128MB logged fk-batch-256 rand seq 3 95.996
100000 100000 128MB logged fk-batch-256 rand rand 3 146.387
100000 100000 128MB unlogged master rand seq 1 199.708
100000 100000 128MB unlogged master rand rand 1 200.429
100000 100000 128MB unlogged master rand seq 2 195.249
100000 100000 128MB unlogged master rand rand 2 203.663
100000 100000 128MB unlogged master rand seq 3 198.870
100000 100000 128MB unlogged master rand rand 3 209.377
100000 100000 128MB unlogged fk-batch-64 rand seq 1 52.097
100000 100000 128MB unlogged fk-batch-64 rand rand 1 96.682
100000 100000 128MB unlogged fk-batch-64 rand seq 2 51.872
100000 100000 128MB unlogged fk-batch-64 rand rand 2 94.544
100000 100000 128MB unlogged fk-batch-64 rand seq 3 50.706
100000 100000 128MB unlogged fk-batch-64 rand rand 3 95.753
100000 100000 128MB unlogged fk-batch-16 rand seq 1 53.738
100000 100000 128MB unlogged fk-batch-16 rand rand 1 85.204
100000 100000 128MB unlogged fk-batch-16 rand seq 2 56.704
100000 100000 128MB unlogged fk-batch-16 rand rand 2 90.824
100000 100000 128MB unlogged fk-batch-16 rand seq 3 49.726
100000 100000 128MB unlogged fk-batch-16 rand rand 3 88.486
100000 100000 128MB unlogged fk-batch-256 rand seq 1 73.783
100000 100000 128MB unlogged fk-batch-256 rand rand 1 123.058
100000 100000 128MB unlogged fk-batch-256 rand seq 2 78.135
100000 100000 128MB unlogged fk-batch-256 rand rand 2 120.007
100000 100000 128MB unlogged fk-batch-256 rand seq 3 75.331
100000 100000 128MB unlogged fk-batch-256 rand rand 3 120.763
100000 100000 8GB logged master rand seq 1 213.903
100000 100000 8GB logged master rand rand 1 219.779
100000 100000 8GB logged master rand seq 2 218.495
100000 100000 8GB logged master rand rand 2 216.864
100000 100000 8GB logged master rand seq 3 215.849
100000 100000 8GB logged master rand rand 3 241.050
100000 100000 8GB logged fk-batch-64 rand seq 1 72.993
100000 100000 8GB logged fk-batch-64 rand rand 1 113.585
100000 100000 8GB logged fk-batch-64 rand seq 2 70.508
100000 100000 8GB logged fk-batch-64 rand rand 2 111.451
100000 100000 8GB logged fk-batch-64 rand seq 3 68.393
100000 100000 8GB logged fk-batch-64 rand rand 3 109.147
100000 100000 8GB logged fk-batch-16 rand seq 1 66.711
100000 100000 8GB logged fk-batch-16 rand rand 1 104.186
100000 100000 8GB logged fk-batch-16 rand seq 2 65.661
100000 100000 8GB logged fk-batch-16 rand rand 2 104.866
100000 100000 8GB logged fk-batch-16 rand seq 3 65.891
100000 100000 8GB logged fk-batch-16 rand rand 3 102.571
100000 100000 8GB logged fk-batch-256 rand seq 1 88.683
100000 100000 8GB logged fk-batch-256 rand rand 1 139.518
100000 100000 8GB logged fk-batch-256 rand seq 2 86.753
100000 100000 8GB logged fk-batch-256 rand rand 2 136.118
100000 100000 8GB logged fk-batch-256 rand seq 3 85.618
100000 100000 8GB logged fk-batch-256 rand rand 3 136.740
100000 100000 8GB unlogged master rand seq 1 201.917
100000 100000 8GB unlogged master rand rand 1 208.975
100000 100000 8GB unlogged master rand seq 2 197.908
100000 100000 8GB unlogged master rand rand 2 204.564
100000 100000 8GB unlogged master rand seq 3 196.583
100000 100000 8GB unlogged master rand rand 3 203.023
100000 100000 8GB unlogged fk-batch-64 rand seq 1 56.230
100000 100000 8GB unlogged fk-batch-64 rand rand 1 103.284
100000 100000 8GB unlogged fk-batch-64 rand seq 2 57.649
100000 100000 8GB unlogged fk-batch-64 rand rand 2 99.131
100000 100000 8GB unlogged fk-batch-64 rand seq 3 54.820
100000 100000 8GB unlogged fk-batch-64 rand rand 3 99.381
100000 100000 8GB unlogged fk-batch-16 rand seq 1 53.437
100000 100000 8GB unlogged fk-batch-16 rand rand 1 90.196
100000 100000 8GB unlogged fk-batch-16 rand seq 2 56.534
100000 100000 8GB unlogged fk-batch-16 rand rand 2 91.846
100000 100000 8GB unlogged fk-batch-16 rand seq 3 55.623
100000 100000 8GB unlogged fk-batch-16 rand rand 3 86.478
100000 100000 8GB unlogged fk-batch-256 rand seq 1 74.560
100000 100000 8GB unlogged fk-batch-256 rand rand 1 126.178
100000 100000 8GB unlogged fk-batch-256 rand seq 2 73.661
100000 100000 8GB unlogged fk-batch-256 rand rand 2 119.451
100000 100000 8GB unlogged fk-batch-256 rand seq 3 70.820
100000 100000 8GB unlogged fk-batch-256 rand rand 3 123.595
100000 1000000 128MB logged master seq seq 1 2066.182
100000 1000000 128MB logged master seq rand 1 2169.647
100000 1000000 128MB logged master seq seq 2 2065.861
100000 1000000 128MB logged master seq rand 2 2218.533
100000 1000000 128MB logged master seq seq 3 2108.618
100000 1000000 128MB logged master seq rand 3 2175.487
100000 1000000 128MB logged fk-batch-64 seq seq 1 518.939
100000 1000000 128MB logged fk-batch-64 seq rand 1 1022.904
100000 1000000 128MB logged fk-batch-64 seq seq 2 516.733
100000 1000000 128MB logged fk-batch-64 seq rand 2 1030.105
100000 1000000 128MB logged fk-batch-64 seq seq 3 532.504
100000 1000000 128MB logged fk-batch-64 seq rand 3 1012.306
100000 1000000 128MB logged fk-batch-16 seq seq 1 486.600
100000 1000000 128MB logged fk-batch-16 seq rand 1 945.971
100000 1000000 128MB logged fk-batch-16 seq seq 2 490.063
100000 1000000 128MB logged fk-batch-16 seq rand 2 939.386
100000 1000000 128MB logged fk-batch-16 seq seq 3 488.034
100000 1000000 128MB logged fk-batch-16 seq rand 3 950.516
100000 1000000 128MB logged fk-batch-256 seq seq 1 736.961
100000 1000000 128MB logged fk-batch-256 seq rand 1 1260.249
100000 1000000 128MB logged fk-batch-256 seq seq 2 731.085
100000 1000000 128MB logged fk-batch-256 seq rand 2 1276.465
100000 1000000 128MB logged fk-batch-256 seq seq 3 746.937
100000 1000000 128MB logged fk-batch-256 seq rand 3 1288.882
100000 1000000 128MB unlogged master seq seq 1 1911.788
100000 1000000 128MB unlogged master seq rand 1 2014.093
100000 1000000 128MB unlogged master seq seq 2 1891.874
100000 1000000 128MB unlogged master seq rand 2 2030.110
100000 1000000 128MB unlogged master seq seq 3 1883.718
100000 1000000 128MB unlogged master seq rand 3 2018.860
100000 1000000 128MB unlogged fk-batch-64 seq seq 1 440.598
100000 1000000 128MB unlogged fk-batch-64 seq rand 1 930.596
100000 1000000 128MB unlogged fk-batch-64 seq seq 2 445.164
100000 1000000 128MB unlogged fk-batch-64 seq rand 2 932.197
100000 1000000 128MB unlogged fk-batch-64 seq seq 3 431.648
100000 1000000 128MB unlogged fk-batch-64 seq rand 3 939.238
100000 1000000 128MB unlogged fk-batch-16 seq seq 1 395.619
100000 1000000 128MB unlogged fk-batch-16 seq rand 1 858.377
100000 1000000 128MB unlogged fk-batch-16 seq seq 2 399.078
100000 1000000 128MB unlogged fk-batch-16 seq rand 2 878.223
100000 1000000 128MB unlogged fk-batch-16 seq seq 3 393.568
100000 1000000 128MB unlogged fk-batch-16 seq rand 3 852.242
100000 1000000 128MB unlogged fk-batch-256 seq seq 1 635.686
100000 1000000 128MB unlogged fk-batch-256 seq rand 1 1174.120
100000 1000000 128MB unlogged fk-batch-256 seq seq 2 628.797
100000 1000000 128MB unlogged fk-batch-256 seq rand 2 1153.743
100000 1000000 128MB unlogged fk-batch-256 seq seq 3 628.549
100000 1000000 128MB unlogged fk-batch-256 seq rand 3 1175.578
100000 1000000 8GB logged master seq seq 1 2034.066
100000 1000000 8GB logged master seq rand 1 2138.664
100000 1000000 8GB logged master seq seq 2 2031.167
100000 1000000 8GB logged master seq rand 2 2107.617
100000 1000000 8GB logged master seq seq 3 2002.897
100000 1000000 8GB logged master seq rand 3 2144.315
100000 1000000 8GB logged fk-batch-64 seq seq 1 518.069
100000 1000000 8GB logged fk-batch-64 seq rand 1 1015.581
100000 1000000 8GB logged fk-batch-64 seq seq 2 510.604
100000 1000000 8GB logged fk-batch-64 seq rand 2 1021.326
100000 1000000 8GB logged fk-batch-64 seq seq 3 516.154
100000 1000000 8GB logged fk-batch-64 seq rand 3 1027.721
100000 1000000 8GB logged fk-batch-16 seq seq 1 485.087
100000 1000000 8GB logged fk-batch-16 seq rand 1 926.395
100000 1000000 8GB logged fk-batch-16 seq seq 2 484.960
100000 1000000 8GB logged fk-batch-16 seq rand 2 922.811
100000 1000000 8GB logged fk-batch-16 seq seq 3 485.520
100000 1000000 8GB logged fk-batch-16 seq rand 3 946.989
100000 1000000 8GB logged fk-batch-256 seq seq 1 717.784
100000 1000000 8GB logged fk-batch-256 seq rand 1 1251.196
100000 1000000 8GB logged fk-batch-256 seq seq 2 725.746
100000 1000000 8GB logged fk-batch-256 seq rand 2 1275.205
100000 1000000 8GB logged fk-batch-256 seq seq 3 724.137
100000 1000000 8GB logged fk-batch-256 seq rand 3 1269.344
100000 1000000 8GB unlogged master seq seq 1 1921.535
100000 1000000 8GB unlogged master seq rand 1 2034.813
100000 1000000 8GB unlogged master seq seq 2 1926.941
100000 1000000 8GB unlogged master seq rand 2 2035.555
100000 1000000 8GB unlogged master seq seq 3 1930.085
100000 1000000 8GB unlogged master seq rand 3 2008.829
100000 1000000 8GB unlogged fk-batch-64 seq seq 1 429.399
100000 1000000 8GB unlogged fk-batch-64 seq rand 1 946.181
100000 1000000 8GB unlogged fk-batch-64 seq seq 2 430.305
100000 1000000 8GB unlogged fk-batch-64 seq rand 2 935.192
100000 1000000 8GB unlogged fk-batch-64 seq seq 3 432.515
100000 1000000 8GB unlogged fk-batch-64 seq rand 3 937.342
100000 1000000 8GB unlogged fk-batch-16 seq seq 1 385.410
100000 1000000 8GB unlogged fk-batch-16 seq rand 1 833.367
100000 1000000 8GB unlogged fk-batch-16 seq seq 2 397.184
100000 1000000 8GB unlogged fk-batch-16 seq rand 2 847.117
100000 1000000 8GB unlogged fk-batch-16 seq seq 3 393.059
100000 1000000 8GB unlogged fk-batch-16 seq rand 3 847.418
100000 1000000 8GB unlogged fk-batch-256 seq seq 1 630.285
100000 1000000 8GB unlogged fk-batch-256 seq rand 1 1168.626
100000 1000000 8GB unlogged fk-batch-256 seq seq 2 645.463
100000 1000000 8GB unlogged fk-batch-256 seq rand 2 1193.996
100000 1000000 8GB unlogged fk-batch-256 seq seq 3 664.016
100000 1000000 8GB unlogged fk-batch-256 seq rand 3 1174.764
100000 1000000 128MB logged master rand seq 1 2064.474
100000 1000000 128MB logged master rand rand 1 2153.819
100000 1000000 128MB logged master rand seq 2 2017.612
100000 1000000 128MB logged master rand rand 2 2133.502
100000 1000000 128MB logged master rand seq 3 2044.938
100000 1000000 128MB logged master rand rand 3 2160.960
100000 1000000 128MB logged fk-batch-64 rand seq 1 578.365
100000 1000000 128MB logged fk-batch-64 rand rand 1 1060.887
100000 1000000 128MB logged fk-batch-64 rand seq 2 593.937
100000 1000000 128MB logged fk-batch-64 rand rand 2 1026.042
100000 1000000 128MB logged fk-batch-64 rand seq 3 590.267
100000 1000000 128MB logged fk-batch-64 rand rand 3 1027.352
100000 1000000 128MB logged fk-batch-16 rand seq 1 551.151
100000 1000000 128MB logged fk-batch-16 rand rand 1 959.842
100000 1000000 128MB logged fk-batch-16 rand seq 2 541.042
100000 1000000 128MB logged fk-batch-16 rand rand 2 955.990
100000 1000000 128MB logged fk-batch-16 rand seq 3 534.648
100000 1000000 128MB logged fk-batch-16 rand rand 3 948.299
100000 1000000 128MB logged fk-batch-256 rand seq 1 783.024
100000 1000000 128MB logged fk-batch-256 rand rand 1 1289.951
100000 1000000 128MB logged fk-batch-256 rand seq 2 785.800
100000 1000000 128MB logged fk-batch-256 rand rand 2 1294.079
100000 1000000 128MB logged fk-batch-256 rand seq 3 802.134
100000 1000000 128MB logged fk-batch-256 rand rand 3 1332.468
100000 1000000 128MB unlogged master rand seq 1 1930.597
100000 1000000 128MB unlogged master rand rand 1 2037.061
100000 1000000 128MB unlogged master rand seq 2 1934.353
100000 1000000 128MB unlogged master rand rand 2 2028.555
100000 1000000 128MB unlogged master rand seq 3 1929.669
100000 1000000 128MB unlogged master rand rand 3 2034.301
100000 1000000 128MB unlogged fk-batch-64 rand seq 1 493.041
100000 1000000 128MB unlogged fk-batch-64 rand rand 1 933.111
100000 1000000 128MB unlogged fk-batch-64 rand seq 2 497.241
100000 1000000 128MB unlogged fk-batch-64 rand rand 2 942.477
100000 1000000 128MB unlogged fk-batch-64 rand seq 3 487.796
100000 1000000 128MB unlogged fk-batch-64 rand rand 3 942.977
100000 1000000 128MB unlogged fk-batch-16 rand seq 1 472.587
100000 1000000 128MB unlogged fk-batch-16 rand rand 1 835.728
100000 1000000 128MB unlogged fk-batch-16 rand seq 2 451.329
100000 1000000 128MB unlogged fk-batch-16 rand rand 2 846.803
100000 1000000 128MB unlogged fk-batch-16 rand seq 3 441.043
100000 1000000 128MB unlogged fk-batch-16 rand rand 3 830.181
100000 1000000 128MB unlogged fk-batch-256 rand seq 1 707.814
100000 1000000 128MB unlogged fk-batch-256 rand rand 1 1186.669
100000 1000000 128MB unlogged fk-batch-256 rand seq 2 686.644
100000 1000000 128MB unlogged fk-batch-256 rand rand 2 1182.996
100000 1000000 128MB unlogged fk-batch-256 rand seq 3 706.391
100000 1000000 128MB unlogged fk-batch-256 rand rand 3 1157.533
100000 1000000 8GB logged master rand seq 1 2044.783
100000 1000000 8GB logged master rand rand 1 2107.537
100000 1000000 8GB logged master rand seq 2 2026.671
100000 1000000 8GB logged master rand rand 2 2114.453
100000 1000000 8GB logged master rand seq 3 2016.388
100000 1000000 8GB logged master rand rand 3 2135.634
100000 1000000 8GB logged fk-batch-64 rand seq 1 578.535
100000 1000000 8GB logged fk-batch-64 rand rand 1 1041.884
100000 1000000 8GB logged fk-batch-64 rand seq 2 572.463
100000 1000000 8GB logged fk-batch-64 rand rand 2 1035.529
100000 1000000 8GB logged fk-batch-64 rand seq 3 586.262
100000 1000000 8GB logged fk-batch-64 rand rand 3 1029.329
100000 1000000 8GB logged fk-batch-16 rand seq 1 547.780
100000 1000000 8GB logged fk-batch-16 rand rand 1 964.646
100000 1000000 8GB logged fk-batch-16 rand seq 2 542.731
100000 1000000 8GB logged fk-batch-16 rand rand 2 956.601
100000 1000000 8GB logged fk-batch-16 rand seq 3 560.423
100000 1000000 8GB logged fk-batch-16 rand rand 3 978.886
100000 1000000 8GB logged fk-batch-256 rand seq 1 794.748
100000 1000000 8GB logged fk-batch-256 rand rand 1 1245.953
100000 1000000 8GB logged fk-batch-256 rand seq 2 780.789
100000 1000000 8GB logged fk-batch-256 rand rand 2 1281.219
100000 1000000 8GB logged fk-batch-256 rand seq 3 796.640
100000 1000000 8GB logged fk-batch-256 rand rand 3 1277.308
100000 1000000 8GB unlogged master rand seq 1 1952.787
100000 1000000 8GB unlogged master rand rand 1 2055.507
100000 1000000 8GB unlogged master rand seq 2 1931.580
100000 1000000 8GB unlogged master rand rand 2 2071.241
100000 1000000 8GB unlogged master rand seq 3 1963.119
100000 1000000 8GB unlogged master rand rand 3 2024.103
100000 1000000 8GB unlogged fk-batch-64 rand seq 1 498.579
100000 1000000 8GB unlogged fk-batch-64 rand rand 1 932.911
100000 1000000 8GB unlogged fk-batch-64 rand seq 2 490.107
100000 1000000 8GB unlogged fk-batch-64 rand rand 2 946.734
100000 1000000 8GB unlogged fk-batch-64 rand seq 3 492.651
100000 1000000 8GB unlogged fk-batch-64 rand rand 3 933.314
100000 1000000 8GB unlogged fk-batch-16 rand seq 1 453.483
100000 1000000 8GB unlogged fk-batch-16 rand rand 1 849.864
100000 1000000 8GB unlogged fk-batch-16 rand seq 2 453.591
100000 1000000 8GB unlogged fk-batch-16 rand rand 2 845.767
100000 1000000 8GB unlogged fk-batch-16 rand seq 3 466.871
100000 1000000 8GB unlogged fk-batch-16 rand rand 3 858.500
100000 1000000 8GB unlogged fk-batch-256 rand seq 1 712.647
100000 1000000 8GB unlogged fk-batch-256 rand rand 1 1215.066
100000 1000000 8GB unlogged fk-batch-256 rand seq 2 712.125
100000 1000000 8GB unlogged fk-batch-256 rand rand 2 1215.166
100000 1000000 8GB unlogged fk-batch-256 rand seq 3 698.764
100000 1000000 8GB unlogged fk-batch-256 rand rand 3 1181.074
1000000 100000 128MB logged master seq seq 1 220.814
1000000 100000 128MB logged master seq rand 1 267.887
1000000 100000 128MB logged master seq seq 2 223.493
1000000 100000 128MB logged master seq rand 2 260.982
1000000 100000 128MB logged master seq seq 3 222.812
1000000 100000 128MB logged master seq rand 3 259.805
1000000 100000 128MB logged fk-batch-64 seq seq 1 62.157
1000000 100000 128MB logged fk-batch-64 seq rand 1 161.676
1000000 100000 128MB logged fk-batch-64 seq seq 2 60.670
1000000 100000 128MB logged fk-batch-64 seq rand 2 152.234
1000000 100000 128MB logged fk-batch-64 seq seq 3 63.490
1000000 100000 128MB logged fk-batch-64 seq rand 3 149.737
1000000 100000 128MB logged fk-batch-16 seq seq 1 60.843
1000000 100000 128MB logged fk-batch-16 seq rand 1 151.589
1000000 100000 128MB logged fk-batch-16 seq seq 2 57.908
1000000 100000 128MB logged fk-batch-16 seq rand 2 142.763
1000000 100000 128MB logged fk-batch-16 seq seq 3 59.006
1000000 100000 128MB logged fk-batch-16 seq rand 3 153.376
1000000 100000 128MB logged fk-batch-256 seq seq 1 82.062
1000000 100000 128MB logged fk-batch-256 seq rand 1 185.183
1000000 100000 128MB logged fk-batch-256 seq seq 2 81.411
1000000 100000 128MB logged fk-batch-256 seq rand 2 175.808
1000000 100000 128MB logged fk-batch-256 seq seq 3 81.915
1000000 100000 128MB logged fk-batch-256 seq rand 3 176.051
1000000 100000 128MB unlogged master seq seq 1 203.354
1000000 100000 128MB unlogged master seq rand 1 236.511
1000000 100000 128MB unlogged master seq seq 2 199.237
1000000 100000 128MB unlogged master seq rand 2 237.526
1000000 100000 128MB unlogged master seq seq 3 202.288
1000000 100000 128MB unlogged master seq rand 3 238.380
1000000 100000 128MB unlogged fk-batch-64 seq seq 1 44.505
1000000 100000 128MB unlogged fk-batch-64 seq rand 1 128.983
1000000 100000 128MB unlogged fk-batch-64 seq seq 2 45.829
1000000 100000 128MB unlogged fk-batch-64 seq rand 2 127.410
1000000 100000 128MB unlogged fk-batch-64 seq seq 3 45.097
1000000 100000 128MB unlogged fk-batch-64 seq rand 3 128.362
1000000 100000 128MB unlogged fk-batch-16 seq seq 1 42.835
1000000 100000 128MB unlogged fk-batch-16 seq rand 1 124.564
1000000 100000 128MB unlogged fk-batch-16 seq seq 2 44.191
1000000 100000 128MB unlogged fk-batch-16 seq rand 2 119.710
1000000 100000 128MB unlogged fk-batch-16 seq seq 3 42.792
1000000 100000 128MB unlogged fk-batch-16 seq rand 3 121.225
1000000 100000 128MB unlogged fk-batch-256 seq seq 1 63.007
1000000 100000 128MB unlogged fk-batch-256 seq rand 1 158.401
1000000 100000 128MB unlogged fk-batch-256 seq seq 2 63.926
1000000 100000 128MB unlogged fk-batch-256 seq rand 2 157.667
1000000 100000 128MB unlogged fk-batch-256 seq seq 3 64.098
1000000 100000 128MB unlogged fk-batch-256 seq rand 3 154.169
1000000 100000 8GB logged master seq seq 1 221.732
1000000 100000 8GB logged master seq rand 1 270.258
1000000 100000 8GB logged master seq seq 2 219.007
1000000 100000 8GB logged master seq rand 2 264.649
1000000 100000 8GB logged master seq seq 3 225.241
1000000 100000 8GB logged master seq rand 3 261.424
1000000 100000 8GB logged fk-batch-64 seq seq 1 61.317
1000000 100000 8GB logged fk-batch-64 seq rand 1 167.084
1000000 100000 8GB logged fk-batch-64 seq seq 2 62.010
1000000 100000 8GB logged fk-batch-64 seq rand 2 147.838
1000000 100000 8GB logged fk-batch-64 seq seq 3 61.449
1000000 100000 8GB logged fk-batch-64 seq rand 3 152.298
1000000 100000 8GB logged fk-batch-16 seq seq 1 60.438
1000000 100000 8GB logged fk-batch-16 seq rand 1 153.254
1000000 100000 8GB logged fk-batch-16 seq seq 2 59.234
1000000 100000 8GB logged fk-batch-16 seq rand 2 143.047
1000000 100000 8GB logged fk-batch-16 seq seq 3 60.079
1000000 100000 8GB logged fk-batch-16 seq rand 3 142.481
1000000 100000 8GB logged fk-batch-256 seq seq 1 82.397
1000000 100000 8GB logged fk-batch-256 seq rand 1 184.509
1000000 100000 8GB logged fk-batch-256 seq seq 2 81.646
1000000 100000 8GB logged fk-batch-256 seq rand 2 178.928
1000000 100000 8GB logged fk-batch-256 seq seq 3 77.727
1000000 100000 8GB logged fk-batch-256 seq rand 3 181.646
1000000 100000 8GB unlogged master seq seq 1 197.999
1000000 100000 8GB unlogged master seq rand 1 235.660
1000000 100000 8GB unlogged master seq seq 2 199.749
1000000 100000 8GB unlogged master seq rand 2 235.883
1000000 100000 8GB unlogged master seq seq 3 201.420
1000000 100000 8GB unlogged master seq rand 3 239.716
1000000 100000 8GB unlogged fk-batch-64 seq seq 1 45.318
1000000 100000 8GB unlogged fk-batch-64 seq rand 1 129.387
1000000 100000 8GB unlogged fk-batch-64 seq seq 2 45.642
1000000 100000 8GB unlogged fk-batch-64 seq rand 2 130.073
1000000 100000 8GB unlogged fk-batch-64 seq seq 3 45.789
1000000 100000 8GB unlogged fk-batch-64 seq rand 3 131.141
1000000 100000 8GB unlogged fk-batch-16 seq seq 1 42.933
1000000 100000 8GB unlogged fk-batch-16 seq rand 1 121.525
1000000 100000 8GB unlogged fk-batch-16 seq seq 2 42.755
1000000 100000 8GB unlogged fk-batch-16 seq rand 2 122.634
1000000 100000 8GB unlogged fk-batch-16 seq seq 3 42.612
1000000 100000 8GB unlogged fk-batch-16 seq rand 3 125.389
1000000 100000 8GB unlogged fk-batch-256 seq seq 1 63.418
1000000 100000 8GB unlogged fk-batch-256 seq rand 1 154.069
1000000 100000 8GB unlogged fk-batch-256 seq seq 2 61.544
1000000 100000 8GB unlogged fk-batch-256 seq rand 2 156.429
1000000 100000 8GB unlogged fk-batch-256 seq seq 3 65.007
1000000 100000 8GB unlogged fk-batch-256 seq rand 3 155.655
1000000 100000 128MB logged master rand seq 1 243.936
1000000 100000 128MB logged master rand rand 1 262.115
1000000 100000 128MB logged master rand seq 2 235.451
1000000 100000 128MB logged master rand rand 2 261.039
1000000 100000 128MB logged master rand seq 3 237.162
1000000 100000 128MB logged master rand rand 3 264.179
1000000 100000 128MB logged fk-batch-64 rand seq 1 94.571
1000000 100000 128MB logged fk-batch-64 rand rand 1 151.687
1000000 100000 128MB logged fk-batch-64 rand seq 2 81.577
1000000 100000 128MB logged fk-batch-64 rand rand 2 149.757
1000000 100000 128MB logged fk-batch-64 rand seq 3 78.003
1000000 100000 128MB logged fk-batch-64 rand rand 3 158.284
1000000 100000 128MB logged fk-batch-16 rand seq 1 88.497
1000000 100000 128MB logged fk-batch-16 rand rand 1 152.095
1000000 100000 128MB logged fk-batch-16 rand seq 2 79.261
1000000 100000 128MB logged fk-batch-16 rand rand 2 144.818
1000000 100000 128MB logged fk-batch-16 rand seq 3 76.881
1000000 100000 128MB logged fk-batch-16 rand rand 3 146.189
1000000 100000 128MB logged fk-batch-256 rand seq 1 113.858
1000000 100000 128MB logged fk-batch-256 rand rand 1 174.752
1000000 100000 128MB logged fk-batch-256 rand seq 2 100.714
1000000 100000 128MB logged fk-batch-256 rand rand 2 179.943
1000000 100000 128MB logged fk-batch-256 rand seq 3 97.183
1000000 100000 128MB logged fk-batch-256 rand rand 3 177.417
1000000 100000 128MB unlogged master rand seq 1 228.699
1000000 100000 128MB unlogged master rand rand 1 235.207
1000000 100000 128MB unlogged master rand seq 2 215.496
1000000 100000 128MB unlogged master rand rand 2 240.848
1000000 100000 128MB unlogged master rand seq 3 211.621
1000000 100000 128MB unlogged master rand rand 3 240.686
1000000 100000 128MB unlogged fk-batch-64 rand seq 1 66.213
1000000 100000 128MB unlogged fk-batch-64 rand rand 1 129.887
1000000 100000 128MB unlogged fk-batch-64 rand seq 2 64.229
1000000 100000 128MB unlogged fk-batch-64 rand rand 2 129.248
1000000 100000 128MB unlogged fk-batch-64 rand seq 3 62.687
1000000 100000 128MB unlogged fk-batch-64 rand rand 3 132.034
1000000 100000 128MB unlogged fk-batch-16 rand seq 1 64.796
1000000 100000 128MB unlogged fk-batch-16 rand rand 1 127.725
1000000 100000 128MB unlogged fk-batch-16 rand seq 2 61.051
1000000 100000 128MB unlogged fk-batch-16 rand rand 2 122.323
1000000 100000 128MB unlogged fk-batch-16 rand seq 3 60.023
1000000 100000 128MB unlogged fk-batch-16 rand rand 3 122.399
1000000 100000 128MB unlogged fk-batch-256 rand seq 1 84.400
1000000 100000 128MB unlogged fk-batch-256 rand rand 1 153.619
1000000 100000 128MB unlogged fk-batch-256 rand seq 2 83.454
1000000 100000 128MB unlogged fk-batch-256 rand rand 2 153.318
1000000 100000 128MB unlogged fk-batch-256 rand seq 3 82.133
1000000 100000 128MB unlogged fk-batch-256 rand rand 3 152.312
1000000 100000 8GB logged master rand seq 1 243.788
1000000 100000 8GB logged master rand rand 1 261.474
1000000 100000 8GB logged master rand seq 2 234.766
1000000 100000 8GB logged master rand rand 2 265.181
1000000 100000 8GB logged master rand seq 3 228.087
1000000 100000 8GB logged master rand rand 3 255.801
1000000 100000 8GB logged fk-batch-64 rand seq 1 90.551
1000000 100000 8GB logged fk-batch-64 rand rand 1 154.460
1000000 100000 8GB logged fk-batch-64 rand seq 2 77.906
1000000 100000 8GB logged fk-batch-64 rand rand 2 149.007
1000000 100000 8GB logged fk-batch-64 rand seq 3 79.312
1000000 100000 8GB logged fk-batch-64 rand rand 3 151.750
1000000 100000 8GB logged fk-batch-16 rand seq 1 92.241
1000000 100000 8GB logged fk-batch-16 rand rand 1 140.952
1000000 100000 8GB logged fk-batch-16 rand seq 2 79.487
1000000 100000 8GB logged fk-batch-16 rand rand 2 146.576
1000000 100000 8GB logged fk-batch-16 rand seq 3 78.979
1000000 100000 8GB logged fk-batch-16 rand rand 3 147.375
1000000 100000 8GB logged fk-batch-256 rand seq 1 116.320
1000000 100000 8GB logged fk-batch-256 rand rand 1 177.712
1000000 100000 8GB logged fk-batch-256 rand seq 2 97.856
1000000 100000 8GB logged fk-batch-256 rand rand 2 177.992
1000000 100000 8GB logged fk-batch-256 rand seq 3 98.029
1000000 100000 8GB logged fk-batch-256 rand rand 3 176.533
1000000 100000 8GB unlogged master rand seq 1 215.037
1000000 100000 8GB unlogged master rand rand 1 240.277
1000000 100000 8GB unlogged master rand seq 2 213.286
1000000 100000 8GB unlogged master rand rand 2 243.229
1000000 100000 8GB unlogged master rand seq 3 210.967
1000000 100000 8GB unlogged master rand rand 3 239.331
1000000 100000 8GB unlogged fk-batch-64 rand seq 1 65.759
1000000 100000 8GB unlogged fk-batch-64 rand rand 1 136.598
1000000 100000 8GB unlogged fk-batch-64 rand seq 2 63.930
1000000 100000 8GB unlogged fk-batch-64 rand rand 2 130.002
1000000 100000 8GB unlogged fk-batch-64 rand seq 3 64.346
1000000 100000 8GB unlogged fk-batch-64 rand rand 3 131.192
1000000 100000 8GB unlogged fk-batch-16 rand seq 1 62.827
1000000 100000 8GB unlogged fk-batch-16 rand rand 1 124.556
1000000 100000 8GB unlogged fk-batch-16 rand seq 2 62.453
1000000 100000 8GB unlogged fk-batch-16 rand rand 2 126.382
1000000 100000 8GB unlogged fk-batch-16 rand seq 3 62.545
1000000 100000 8GB unlogged fk-batch-16 rand rand 3 124.432
1000000 100000 8GB unlogged fk-batch-256 rand seq 1 85.560
1000000 100000 8GB unlogged fk-batch-256 rand rand 1 159.837
1000000 100000 8GB unlogged fk-batch-256 rand seq 2 83.715
1000000 100000 8GB unlogged fk-batch-256 rand rand 2 159.849
1000000 100000 8GB unlogged fk-batch-256 rand seq 3 84.697
1000000 100000 8GB unlogged fk-batch-256 rand rand 3 157.713
1000000 1000000 128MB logged master seq seq 1 2243.310
1000000 1000000 128MB logged master seq rand 1 2504.169
1000000 1000000 128MB logged master seq seq 2 2227.222
1000000 1000000 128MB logged master seq rand 2 2524.127
1000000 1000000 128MB logged master seq seq 3 2342.231
1000000 1000000 128MB logged master seq rand 3 2559.448
1000000 1000000 128MB logged fk-batch-64 seq seq 1 611.147
1000000 1000000 128MB logged fk-batch-64 seq rand 1 1376.332
1000000 1000000 128MB logged fk-batch-64 seq seq 2 623.607
1000000 1000000 128MB logged fk-batch-64 seq rand 2 1369.031
1000000 1000000 128MB logged fk-batch-64 seq seq 3 605.777
1000000 1000000 128MB logged fk-batch-64 seq rand 3 1369.016
1000000 1000000 128MB logged fk-batch-16 seq seq 1 585.545
1000000 1000000 128MB logged fk-batch-16 seq rand 1 1288.182
1000000 1000000 128MB logged fk-batch-16 seq seq 2 593.336
1000000 1000000 128MB logged fk-batch-16 seq rand 2 1303.607
1000000 1000000 128MB logged fk-batch-16 seq seq 3 589.324
1000000 1000000 128MB logged fk-batch-16 seq rand 3 1302.692
1000000 1000000 128MB logged fk-batch-256 seq seq 1 805.271
1000000 1000000 128MB logged fk-batch-256 seq rand 1 1608.974
1000000 1000000 128MB logged fk-batch-256 seq seq 2 805.628
1000000 1000000 128MB logged fk-batch-256 seq rand 2 1640.395
1000000 1000000 128MB logged fk-batch-256 seq seq 3 813.196
1000000 1000000 128MB logged fk-batch-256 seq rand 3 1615.017
1000000 1000000 128MB unlogged master seq seq 1 2006.885
1000000 1000000 128MB unlogged master seq rand 1 2249.206
1000000 1000000 128MB unlogged master seq seq 2 2029.677
1000000 1000000 128MB unlogged master seq rand 2 2234.653
1000000 1000000 128MB unlogged master seq seq 3 2059.893
1000000 1000000 128MB unlogged master seq rand 3 2283.031
1000000 1000000 128MB unlogged fk-batch-64 seq seq 1 452.741
1000000 1000000 128MB unlogged fk-batch-64 seq rand 1 1190.773
1000000 1000000 128MB unlogged fk-batch-64 seq seq 2 448.749
1000000 1000000 128MB unlogged fk-batch-64 seq rand 2 1182.929
1000000 1000000 128MB unlogged fk-batch-64 seq seq 3 464.480
1000000 1000000 128MB unlogged fk-batch-64 seq rand 3 1190.300
1000000 1000000 128MB unlogged fk-batch-16 seq seq 1 436.425
1000000 1000000 128MB unlogged fk-batch-16 seq rand 1 1128.575
1000000 1000000 128MB unlogged fk-batch-16 seq seq 2 439.448
1000000 1000000 128MB unlogged fk-batch-16 seq rand 2 1120.044
1000000 1000000 128MB unlogged fk-batch-16 seq seq 3 431.372
1000000 1000000 128MB unlogged fk-batch-16 seq rand 3 1130.315
1000000 1000000 128MB unlogged fk-batch-256 seq seq 1 673.467
1000000 1000000 128MB unlogged fk-batch-256 seq rand 1 1464.679
1000000 1000000 128MB unlogged fk-batch-256 seq seq 2 673.437
1000000 1000000 128MB unlogged fk-batch-256 seq rand 2 1480.259
1000000 1000000 128MB unlogged fk-batch-256 seq seq 3 675.804
1000000 1000000 128MB unlogged fk-batch-256 seq rand 3 1446.883
1000000 1000000 8GB logged master seq seq 1 2156.729
1000000 1000000 8GB logged master seq rand 1 2454.379
1000000 1000000 8GB logged master seq seq 2 2200.500
1000000 1000000 8GB logged master seq rand 2 2467.937
1000000 1000000 8GB logged master seq seq 3 2207.761
1000000 1000000 8GB logged master seq rand 3 2502.242
1000000 1000000 8GB logged fk-batch-64 seq seq 1 625.416
1000000 1000000 8GB logged fk-batch-64 seq rand 1 1377.538
1000000 1000000 8GB logged fk-batch-64 seq seq 2 607.226
1000000 1000000 8GB logged fk-batch-64 seq rand 2 1361.853
1000000 1000000 8GB logged fk-batch-64 seq seq 3 616.755
1000000 1000000 8GB logged fk-batch-64 seq rand 3 1361.215
1000000 1000000 8GB logged fk-batch-16 seq seq 1 584.582
1000000 1000000 8GB logged fk-batch-16 seq rand 1 1294.896
1000000 1000000 8GB logged fk-batch-16 seq seq 2 581.105
1000000 1000000 8GB logged fk-batch-16 seq rand 2 1291.862
1000000 1000000 8GB logged fk-batch-16 seq seq 3 592.587
1000000 1000000 8GB logged fk-batch-16 seq rand 3 1278.656
1000000 1000000 8GB logged fk-batch-256 seq seq 1 808.029
1000000 1000000 8GB logged fk-batch-256 seq rand 1 1593.173
1000000 1000000 8GB logged fk-batch-256 seq seq 2 802.102
1000000 1000000 8GB logged fk-batch-256 seq rand 2 1596.908
1000000 1000000 8GB logged fk-batch-256 seq seq 3 806.365
1000000 1000000 8GB logged fk-batch-256 seq rand 3 1592.340
1000000 1000000 8GB unlogged master seq seq 1 1980.919
1000000 1000000 8GB unlogged master seq rand 1 2261.488
1000000 1000000 8GB unlogged master seq seq 2 2000.620
1000000 1000000 8GB unlogged master seq rand 2 2276.020
1000000 1000000 8GB unlogged master seq seq 3 2000.127
1000000 1000000 8GB unlogged master seq rand 3 2275.317
1000000 1000000 8GB unlogged fk-batch-64 seq seq 1 452.115
1000000 1000000 8GB unlogged fk-batch-64 seq rand 1 1193.541
1000000 1000000 8GB unlogged fk-batch-64 seq seq 2 463.281
1000000 1000000 8GB unlogged fk-batch-64 seq rand 2 1208.442
1000000 1000000 8GB unlogged fk-batch-64 seq seq 3 463.508
1000000 1000000 8GB unlogged fk-batch-64 seq rand 3 1196.873
1000000 1000000 8GB unlogged fk-batch-16 seq seq 1 416.895
1000000 1000000 8GB unlogged fk-batch-16 seq rand 1 1121.031
1000000 1000000 8GB unlogged fk-batch-16 seq seq 2 431.292
1000000 1000000 8GB unlogged fk-batch-16 seq rand 2 1135.553
1000000 1000000 8GB unlogged fk-batch-16 seq seq 3 427.947
1000000 1000000 8GB unlogged fk-batch-16 seq rand 3 1115.223
1000000 1000000 8GB unlogged fk-batch-256 seq seq 1 624.395
1000000 1000000 8GB unlogged fk-batch-256 seq rand 1 1432.945
1000000 1000000 8GB unlogged fk-batch-256 seq seq 2 644.543
1000000 1000000 8GB unlogged fk-batch-256 seq rand 2 1484.782
1000000 1000000 8GB unlogged fk-batch-256 seq seq 3 637.851
1000000 1000000 8GB unlogged fk-batch-256 seq rand 3 1428.959
1000000 1000000 128MB logged master rand seq 1 2288.946
1000000 1000000 128MB logged master rand rand 1 2472.455
1000000 1000000 128MB logged master rand seq 2 2339.352
1000000 1000000 128MB logged master rand rand 2 2470.343
1000000 1000000 128MB logged master rand seq 3 2291.865
1000000 1000000 128MB logged master rand rand 3 2514.453
1000000 1000000 128MB logged fk-batch-64 rand seq 1 768.789
1000000 1000000 128MB logged fk-batch-64 rand rand 1 1418.920
1000000 1000000 128MB logged fk-batch-64 rand seq 2 768.941
1000000 1000000 128MB logged fk-batch-64 rand rand 2 1386.594
1000000 1000000 128MB logged fk-batch-64 rand seq 3 769.859
1000000 1000000 128MB logged fk-batch-64 rand rand 3 1392.249
1000000 1000000 128MB logged fk-batch-16 rand seq 1 738.884
1000000 1000000 128MB logged fk-batch-16 rand rand 1 1327.125
1000000 1000000 128MB logged fk-batch-16 rand seq 2 750.114
1000000 1000000 128MB logged fk-batch-16 rand rand 2 1315.436
1000000 1000000 128MB logged fk-batch-16 rand seq 3 747.513
1000000 1000000 128MB logged fk-batch-16 rand rand 3 1305.668
1000000 1000000 128MB logged fk-batch-256 rand seq 1 948.494
1000000 1000000 128MB logged fk-batch-256 rand rand 1 1617.812
1000000 1000000 128MB logged fk-batch-256 rand seq 2 949.088
1000000 1000000 128MB logged fk-batch-256 rand rand 2 1667.243
1000000 1000000 128MB logged fk-batch-256 rand seq 3 956.461
1000000 1000000 128MB logged fk-batch-256 rand rand 3 1668.339
1000000 1000000 128MB unlogged master rand seq 1 2094.302
1000000 1000000 128MB unlogged master rand rand 1 2288.129
1000000 1000000 128MB unlogged master rand seq 2 2122.496
1000000 1000000 128MB unlogged master rand rand 2 2258.729
1000000 1000000 128MB unlogged master rand seq 3 2120.392
1000000 1000000 128MB unlogged master rand rand 3 2267.389
1000000 1000000 128MB unlogged fk-batch-64 rand seq 1 609.785
1000000 1000000 128MB unlogged fk-batch-64 rand rand 1 1222.693
1000000 1000000 128MB unlogged fk-batch-64 rand seq 2 604.692
1000000 1000000 128MB unlogged fk-batch-64 rand rand 2 1224.682
1000000 1000000 128MB unlogged fk-batch-64 rand seq 3 594.075
1000000 1000000 128MB unlogged fk-batch-64 rand rand 3 1227.637
1000000 1000000 128MB unlogged fk-batch-16 rand seq 1 579.543
1000000 1000000 128MB unlogged fk-batch-16 rand rand 1 1127.228
1000000 1000000 128MB unlogged fk-batch-16 rand seq 2 577.821
1000000 1000000 128MB unlogged fk-batch-16 rand rand 2 1152.122
1000000 1000000 128MB unlogged fk-batch-16 rand seq 3 558.292
1000000 1000000 128MB unlogged fk-batch-16 rand rand 3 1117.745
1000000 1000000 128MB unlogged fk-batch-256 rand seq 1 805.232
1000000 1000000 128MB unlogged fk-batch-256 rand rand 1 1523.166
1000000 1000000 128MB unlogged fk-batch-256 rand seq 2 814.247
1000000 1000000 128MB unlogged fk-batch-256 rand rand 2 1451.871
1000000 1000000 128MB unlogged fk-batch-256 rand seq 3 770.274
1000000 1000000 128MB unlogged fk-batch-256 rand rand 3 1439.346
1000000 1000000 8GB logged master rand seq 1 2275.693
1000000 1000000 8GB logged master rand rand 1 2504.881
1000000 1000000 8GB logged master rand seq 2 2306.109
1000000 1000000 8GB logged master rand rand 2 2501.158
1000000 1000000 8GB logged master rand seq 3 2288.431
1000000 1000000 8GB logged master rand rand 3 2507.251
1000000 1000000 8GB logged fk-batch-64 rand seq 1 748.777
1000000 1000000 8GB logged fk-batch-64 rand rand 1 1391.713
1000000 1000000 8GB logged fk-batch-64 rand seq 2 763.053
1000000 1000000 8GB logged fk-batch-64 rand rand 2 1386.085
1000000 1000000 8GB logged fk-batch-64 rand seq 3 765.186
1000000 1000000 8GB logged fk-batch-64 rand rand 3 1393.078
1000000 1000000 8GB logged fk-batch-16 rand seq 1 749.338
1000000 1000000 8GB logged fk-batch-16 rand rand 1 1320.933
1000000 1000000 8GB logged fk-batch-16 rand seq 2 745.156
1000000 1000000 8GB logged fk-batch-16 rand rand 2 1300.131
1000000 1000000 8GB logged fk-batch-16 rand seq 3 733.864
1000000 1000000 8GB logged fk-batch-16 rand rand 3 1319.178
1000000 1000000 8GB logged fk-batch-256 rand seq 1 944.934
1000000 1000000 8GB logged fk-batch-256 rand rand 1 1669.317
1000000 1000000 8GB logged fk-batch-256 rand seq 2 1017.099
1000000 1000000 8GB logged fk-batch-256 rand rand 2 1655.250
1000000 1000000 8GB logged fk-batch-256 rand seq 3 966.434
1000000 1000000 8GB logged fk-batch-256 rand rand 3 1623.713
1000000 1000000 8GB unlogged master rand seq 1 2131.776
1000000 1000000 8GB unlogged master rand rand 1 2316.881
1000000 1000000 8GB unlogged master rand seq 2 2094.984
1000000 1000000 8GB unlogged master rand rand 2 2313.643
1000000 1000000 8GB unlogged master rand seq 3 2115.305
1000000 1000000 8GB unlogged master rand rand 3 2316.730
1000000 1000000 8GB unlogged fk-batch-64 rand seq 1 574.045
1000000 1000000 8GB unlogged fk-batch-64 rand rand 1 1215.553
1000000 1000000 8GB unlogged fk-batch-64 rand seq 2 606.156
1000000 1000000 8GB unlogged fk-batch-64 rand rand 2 1221.227
1000000 1000000 8GB unlogged fk-batch-64 rand seq 3 586.310
1000000 1000000 8GB unlogged fk-batch-64 rand rand 3 1238.755
1000000 1000000 8GB unlogged fk-batch-16 rand seq 1 551.127
1000000 1000000 8GB unlogged fk-batch-16 rand rand 1 1133.313
1000000 1000000 8GB unlogged fk-batch-16 rand seq 2 570.812
1000000 1000000 8GB unlogged fk-batch-16 rand rand 2 1141.484
1000000 1000000 8GB unlogged fk-batch-16 rand seq 3 569.589
1000000 1000000 8GB unlogged fk-batch-16 rand rand 3 1139.997
1000000 1000000 8GB unlogged fk-batch-256 rand seq 1 771.014
1000000 1000000 8GB unlogged fk-batch-256 rand rand 1 1508.897
1000000 1000000 8GB unlogged fk-batch-256 rand seq 2 782.011
1000000 1000000 8GB unlogged fk-batch-256 rand rand 2 1490.090
1000000 1000000 8GB unlogged fk-batch-256 rand seq 3 787.984
1000000 1000000 8GB unlogged fk-batch-256 rand rand 3 1480.928
[text/csv] fk-batch-pgbench.csv (71.1K, 3-fk-batch-pgbench.csv)
download
[application/x-shellscript] run-pattern.sh (2.6K, 4-run-pattern.sh)
download
[application/x-shellscript] run-pgbench.sh (2.4K, 5-run-pgbench.sh)
download
[application/pdf] fk-batching-patterns.pdf (57.1K, 6-fk-batching-patterns.pdf)
download
[application/pdf] fk-batching-pgbench.pdf (66.6K, 7-fk-batching-pgbench.pdf)
download
view thread (58+ messages) latest in thread
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox