Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:f71fe75f09c3450a8c47e3a576d711b9 Secret

Created January 10, 2024 17:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/f71fe75f09c3450a8c47e3a576d711b9 to your computer and use it in GitHub Desktop.
Save mdcallag/f71fe75f09c3450a8c47e3a576d711b9 to your computer and use it in GitHub Desktop.
Download ZIP
PG, cached, l.i2
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment