#PostgreSQL #Docker. Pure. #RAID5
Model Family: Seagate Constellation ES.2 (SATA 6Gb/s)

pgbench --host 127.0.0.1 --port 20001 --username pgbench --protocol=prepared -P 30 --time=300 --client=50 --jobs=200 pgbench

transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: prepared
number of clients: 50
number of threads: 50
duration: 300 s
number of transactions actually processed: 34293
latency average = 437.711 ms
latency stddev = 523.100 ms
tps = 114.138380 (including connections establishing)
tps = 114.144633 (excluding connections establishing)

PostgreSQL Docker. Tuned. Same setup

pgbench --host 127.0.0.1 --port 20002 --username pgbench --protocol=prepared -P 30 --time=300 --client=50 --jobs=200 pgbench

transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: prepared
number of clients: 50
number of threads: 50
duration: 300 s
number of transactions actually processed: 34270
latency average = 437.918 ms
latency stddev = 513.038 ms
tps = 114.077176 (including connections establishing)
tps = 114.097972 (excluding connections establishing)

#Windows10. No docker. Single #Samsung SSD 970 EVO Plus 1TB

pgbench --host 127.0.0.1 --port 5432 --username pgbench --protocol=prepared -P 30 --time=300 --client=50 --jobs=200 pgbench

transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: prepared
number of clients: 50
number of threads: 50
duration: 300 s
number of transactions actually processed: 1161892
latency average = 12.899 ms
latency stddev = 16.551 ms
tps = 3872.717477 (including connections establishing)
tps = 3876.130444 (excluding connections establishing)

:(

via nekocave.xyz/display/a8d7043b-…

#it