pg, cached, l.i1

gistfile1.txt

-- Postgres 10.23

1 processes, 40000000 rows-per-process, 2116 seconds, 18903.5 rows-per-second, 18903.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
423     50.0    0.2     93.6    28.2    0.003   0.012   0.005   1.525   18903.5

nsamp   cs/s    cpu/s   cs/q    cpu/q
444     9418    23.7    0.498   0.001253

dbGB    8.211
dbdirGB 40.186  /data/m/pg

-- Postgres 11.19

1 processes, 40000000 rows-per-process, 3493 seconds, 11451.4 rows-per-second, 11451.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
698     31.6    0.1     59.7    15.8    0.003   0.013   0.005   1.411   11451.4

nsamp   cs/s    cpu/s   cs/q    cpu/q
732     5841    18.5    0.510   0.001619

dbGB    8.281
dbdirGB 30.741  /data/m/pg

-- Postgres 11.22

1 processes, 40000000 rows-per-process, 3487 seconds, 11471.1 rows-per-second, 11471.1 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
697     31.2    0.1     59.4    15.9    0.003   0.013   0.005   1.416   11471.1

nsamp   cs/s    cpu/s   cs/q    cpu/q
731     5854    18.6    0.510   0.001623

dbGB    8.334
dbdirGB 31.170  /data/m/pg

-- Postgres 12.17

1 processes, 40000000 rows-per-process, 2201 seconds, 18173.5 rows-per-second, 18173.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
440     49.9    0.2     90.8    26.3    0.003   0.013   0.005   1.483   18173.5

nsamp   cs/s    cpu/s   cs/q    cpu/q
461     9092    22.9    0.500   0.001263

dbGB    8.173
dbdirGB 38.820  /data/m/pg

-- Postgres 13.10

1 processes, 40000000 rows-per-process, 2158 seconds, 18535.6 rows-per-second, 18535.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
431     52.3    0.2     92.6    27.0    0.003   0.012   0.005   1.490   18535.6

nsamp   cs/s    cpu/s   cs/q    cpu/q
452     9281    22.6    0.501   0.001222

iostat, vmstat normalized by query rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/q     rKB/q   w/q     wKB/q   qps

nsamp   cs/s    cpu/s   cs/q    cpu/q

dbGB    8.047
dbdirGB 39.200  /data/m/pg

-- Postgres 13.13

1 processes, 40000000 rows-per-process, 2509 seconds, 15942.6 rows-per-second, 15942.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
501     47.3    0.2     81.7    22.1    0.003   0.012   0.005   1.419   15942.6

nsamp   cs/s    cpu/s   cs/q    cpu/q
525     8047    21.8    0.505   0.001367

iostat, vmstat normalized by query rate
nsamp   r/s     rMB/s   w/s     wMB/s   r/q     rKB/q   w/q     wKB/q   qps

nsamp   cs/s    cpu/s   cs/q    cpu/q

dbGB    8.173
dbdirGB 36.274  /data/m/pg

-- Postgres 14.10

1 processes, 40000000 rows-per-process, 2101 seconds, 19038.5 rows-per-second, 19038.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
420     136.5   1.0     89.2    26.6    0.007   0.054   0.005   1.433   19038.5

nsamp   cs/s    cpu/s   cs/q    cpu/q
441     9526    21.4    0.500   0.001126

dbGB    7.898
dbdirGB 39.195  /data/m/pg