#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 pgbenchtransaction 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 pgbenchtransaction 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 pgbenchtransaction 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
@Taciturn Звонок другу: почему обычный 2TB работает в 34 раза быстрее чем Raid5 на Seagate Constellation ES.2? Это деградация от тормозных Сигейтов (с заявленными 6 GB/s) или от Raid5?
Мне пришлось дропнуть pg_restore, который длился без конца и края уже 7 дней и включить старый комп. Это невыносимо долго
первое что я сделал это cat mdstat
root@Mutsu ~ # cat /proc/mdstat
Personalities : [raid1] [raid6] [raid5] [raid4] [linear] [multipath] [raid0]
[raid10]md1 : active raid1 sdd2[1] sdb2[0] sda2[2] sdc2
[3] 523264 blocks super 1.2 [4/4][UUUU]md2 : active raid5 sdb3[0] sdd3[1] sda3[2] sdc3
[4] 8587496448 blocks super 1.2 level 5, 512k chunk, algorithm 2 [4/4]
[UUUU] bitmap: 6/22 pages [24KB], 65536KB chunkmd0 : active raid1 sdd1[1] sda1[2] sdc1[3] sdb1
[0] 67042304 blocks super 1.2 [4/4][UUUU]unused devices: <none>
Windows 10. No docker. Tuned. #WesternDigital WDC WD10EZEX-00WN4A0