Linux syth postgres io workload

blkdev_max.fio

[global]
  ioengine=libaio
  direct=1
  invalidate=1
  verify=0
  ramp_time=2s
  randrepeat=0
  time_based
  runtime=5m
  filesize=2G
  #exec_prerun="echo 3 > /proc/sys/vm/drop_caches"

  
[bandwidth-read]
  stonewall
  blocksize=128k
  iodepth=64
  rw=randread

[bandwidth-write]
  stonewall
  blocksize=1M
  iodepth=32
  rw=randwrite

[iops-read]
  stonewall
  iodepth=64
  rw=randread

[iops-write]
  stonewall
  iodepth=64
  rw=randwrite

[lattency-read]
  stonewall
  iodepth=4
  rw=randread

[lattency-write]
  stonewall
  iodepth=4
  rw=randwrite

[seq-read]
  stonewall
  blocksize=1M
  iodepth=16
  rw=read

db_test.fio

#pulled from https://blog.dbi-services.com/flexible-io-simulating-database-like-io-activity-without-an-installed-database/

[global]
  fadvise_hint=0
  ioengine=libaio
  blocksize=4k
  direct=1
  runtime=300
  time_based
  numjobs=${io_thread}
  rwmixread=${ratio}
# To free pagecache, dentries and inodes (only possible as root, therefore commented out) :
# exec_prerun=echo 3 > /proc/sys/vm/drop_caches

[seq-read]
        rw=read
        size=512M
        directory=/tmp
        numjobs=1
        nrfiles=8

[seq-write]
  rw=write
  size=512M
  directory=/tmp
  numjobs=1
  nrfiles=8
  fsync=1

[random-read]
  rw=randread
  size=1g
  directory=/tmp
  numjobs=8
  nrfiles=1

[random-write]
  rw=randwrite
  size=1g
  directory=/tmp
  numjobs=8
  nrfiles=1
  fsync=100


[active-db]
  rw=rw
  rwmixread=80
  size=1g
  directory=/tmp
  numjobs=8
  nrfiles=8
  fsync=100