#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
@nokitakaze Windows 10. No docker. Tuned. #WesternDigital WDC WD10EZEX-00WN4A0

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

transaction type: <builtin: TPC-B (sort of)>
scaling factor: 1
query mode: prepared
number of clients: 20
number of threads: 20
duration: 300 s
number of transactions actually processed: 1069747
latency average = 5.606 ms
latency stddev = 7.105 ms
tps = 3565.639504 (including connections establishing)
tps = 3567.505530 (excluding connections establishing)

@nokitakaze @Taciturn Звонок другу: почему обычный 2TB работает в 34 раза быстрее чем Raid5 на Seagate Constellation ES.2? Это деградация от тормозных Сигейтов (с заявленными 6 GB/s) или от Raid5?

Мне пришлось дропнуть pg_restore, который длился без конца и края уже 7 дней и включить старый комп. Это невыносимо долго
Follow

@nokitakaze Если и RAID5, то либо перестраивающийся, либо без одного диска. Скорее всего проблема в дисках. Я бы одному попробовал с них читать, например через DD, возможно на каком-то будет сильная просадка скорости. Ещё можно на SMART погадать, но это не точно.

· · Web · 1 · 0 · 0
@nokitakaze @Taciturn первое что я сделал это cat mdstat

[email protected] ~ # 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 chunk

md0 : active raid1 sdd1[1] sda1[2] sdc1[3] sdb1[0]
67042304 blocks super 1.2 [4/4] [UUUU]

unused devices: <none>

Sign in to participate in the conversation
Mastodon

lor.sh is yet another mastodon instance.