накопитель Samsung 970 EVO Plus [MZ-V7S500BW] 500 ГБ SSD M.2

Лучшие практики

Flexible I/O Tester - fio-3.1 (C) axboe
                          Fio Github : https://github.com/axboe/fio
                       Script Source : https://unix.stackexchange.com/a/480191/72554
-----------------------------------------------------------------------
* MB/s = 1,000,000 bytes/s
* KB = 1000 bytes, KiB = 1024 bytes

   Legacy Seq Read (Q=  1,T= 1) :   3339MB/s [   3 IOPS]
  Legacy Seq Write (Q=  1,T= 1) :   2915MB/s [   2 IOPS]
   512KiB Seq Read (Q=  1,T= 1) :   1780MB/s [   3478 IOPS]
  512KiB Seq Write (Q=  1,T= 1) :   1780MB/s [   3478 IOPS]
   Sequential Read (Q= 32,T= 1) :   3335MB/s [   101 IOPS]
  Sequential Write (Q= 32,T= 1) :   3183MB/s [   97 IOPS]
  Random Read 4KiB (Q=  8,T= 8) :   1786MB/s [   446661 IOPS]
 Random Write 4KiB (Q=  8,T= 8) :   2641MB/s [   660460 IOPS]
  Random Read 4KiB (Q= 32,T= 1) :   1213MB/s [   303407 IOPS]
 Random Write 4KiB (Q= 32,T= 1) :   1178MB/s [   294676 IOPS]
  Random Read 4KiB (Q=  1,T= 1) :   81MB/s [   20469 IOPS]
 Random Write 4KiB (Q=  1,T= 1) :   312MB/s [   78019 IOPS]

  Test : 1024 MiB [,   (/ GiB] (x5)  [Interval=0 sec]
  Date : 2020/02/19 12:56:08
    OS : Linux 4.15.0-88-generic x86_64

sudo su postgres
psql -c "CREATE DATABASE example;"
pgbench -i -s 2000 example
pgbench -U postgres -j 32 -c 32 -T 120 -v -P 5 example

$ pgbench -U postgres -j 32 -c 32 -T 120 -v -P 5 example
starting vacuum...end.
starting vacuum pgbench_accounts...end.
progress: 5.0 s, 9559.1 tps, lat 3.329 ms stddev 1.234
progress: 10.0 s, 9755.8 tps, lat 3.280 ms stddev 0.974
progress: 15.0 s, 9852.0 tps, lat 3.247 ms stddev 1.425
progress: 20.0 s, 9704.4 tps, lat 3.298 ms stddev 1.439
progress: 25.0 s, 9030.2 tps, lat 3.543 ms stddev 5.686
progress: 30.0 s, 9256.2 tps, lat 3.458 ms stddev 4.735
progress: 35.0 s, 9321.8 tps, lat 3.432 ms stddev 3.781
progress: 40.0 s, 9653.2 tps, lat 3.315 ms stddev 1.390
progress: 45.0 s, 9631.8 tps, lat 3.322 ms stddev 1.797
progress: 50.0 s, 8733.0 tps, lat 3.661 ms stddev 6.154
progress: 55.0 s, 8955.4 tps, lat 3.576 ms stddev 5.232
progress: 60.0 s, 9405.0 tps, lat 3.403 ms stddev 2.684
progress: 65.0 s, 9467.4 tps, lat 3.380 ms stddev 2.021
progress: 70.0 s, 8631.4 tps, lat 3.705 ms stddev 6.013
progress: 75.0 s, 8608.2 tps, lat 3.720 ms stddev 6.097
progress: 80.0 s, 8791.2 tps, lat 3.640 ms stddev 5.915
progress: 85.0 s, 9561.2 tps, lat 3.347 ms stddev 2.498
progress: 90.0 s, 9628.0 tps, lat 3.323 ms stddev 2.033
progress: 95.0 s, 9659.4 tps, lat 3.312 ms stddev 1.658
progress: 100.0 s, 9259.4 tps, lat 3.457 ms stddev 4.773
progress: 105.0 s, 8601.0 tps, lat 3.720 ms stddev 6.487
progress: 110.0 s, 7127.6 tps, lat 4.488 ms stddev 9.495
progress: 115.0 s, 7803.4 tps, lat 4.102 ms stddev 5.758
progress: 120.0 s, 7866.9 tps, lat 4.064 ms stddev 4.158
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 2000
query mode: simple
number of clients: 32
number of threads: 32
duration: 120 s
number of transactions actually processed: 1089348
latency average = 3.525 ms
latency stddev = 4.351 ms
tps = 9074.854954 (including connections establishing)
tps = 9076.273199 (excluding connections establishing)



psql -c "DROP DATABASE example;"