This has graphs of throughput vs time for three of the Insert Benchmark steps. The goal is to determine whether there is too much variance. A common source of variance is checkpoint stalls when using a B-Tree. This is a follow up to my blog post on the Insert Benchmark for Postgres versions 12.11, 13.7, 14.3 and 15b1.
The benchmark steps for which graphs are provided are:
- l.i0 - load in PK order without secondary indexes
- l.i1 - load in PK order with 3 secondary indexes