PG, cached, l.i2

gistfile1.txt

-- PG 10.23

$ head -20 30m.pg1023_def.cx9a2_bee/l.i2/o.res.dop1
1 processes, 10000000 rows-per-process, 3006 seconds, 3326.6 rows-per-second, 3326.6 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
600     0.0     0.0     39.2    8.4     0.000   0.000   0.012   2.574   3326.6

nsamp   cs/s    cpu/s   cs/q    cpu/q
629     16081   17.2    4.834   0.005157

dbGB    8.284
dbdirGB 44.119  /data/m/pg

-- PG 11.19

1 processes, 10000000 rows-per-process, 5624 seconds, 1778.0 rows-per-second, 1778.0 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
1124    0.0     0.0     27.0    4.6     0.000   0.000   0.015   2.665   1778.0

nsamp   cs/s    cpu/s   cs/q    cpu/q
1178    8769    14.7    4.932   0.008285

dbGB    8.361
dbdirGB 29.559  /data/m/pg

-- PG 11.22

1 processes, 10000000 rows-per-process, 4267 seconds, 2343.5 rows-per-second, 2343.5 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
853     0.0     0.0     28.5    5.1     0.000   0.000   0.012   2.242   2343.5

nsamp   cs/s    cpu/s   cs/q    cpu/q
894     11473   15.5    4.896   0.006611

dbGB    8.411
dbdirGB 30.480  /data/m/pg

-- PG 12.17

1 processes, 10000000 rows-per-process, 3547 seconds, 2819.2 rows-per-second, 2819.2 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
709     0.0     0.0     29.6    5.7     0.000   0.000   0.011   2.073   2819.2

nsamp   cs/s    cpu/s   cs/q    cpu/q
743     13678   16.4    4.852   0.005815

dbGB    8.215
dbdirGB 38.448  /data/m/pg

-- PG 13.10

1 processes, 10000000 rows-per-process, 1592 seconds, 6281.4 rows-per-second, 6281.4 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
318     0.0     0.0     36.2    8.3     0.000   0.000   0.006   1.355   6281.4

nsamp   cs/s    cpu/s   cs/q    cpu/q
334     30236   21.2    4.814   0.003373

dbGB    8.134
dbdirGB 39.296  /data/m/pg

-- PG 13.13

1 processes, 10000000 rows-per-process, 2782 seconds, 3594.5 rows-per-second, 3594.5 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
555     0.0     0.0     32.9    6.7     0.000   0.000   0.009   1.909   3594.5

nsamp   cs/s    cpu/s   cs/q    cpu/q
582     17284   17.5    4.809   0.004863

dbGB    8.226
dbdirGB 36.333  /data/m/pg

-- PG 14.10

1 processes, 10000000 rows-per-process, 1697 seconds, 5892.7 rows-per-second, 5892.7 rows-per-second-per-user, 0 queries, 0 queries-per-second, yes deletes

iostat, vmstat normalized by insert rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/i     rKB/i   w/i     wKB/i   ips
339     0.0     0.0     37.9    9.2     0.000   0.000   0.006   1.605   5892.7

nsamp   cs/s    cpu/s   cs/q    cpu/q
356     28095   20.3    4.768   0.003449

dbGB    7.981
dbdirGB 41.859  /data/m/pg