Estamos testando o PostgreSQL em um array SSD RAID-0 com uma tabela de 10 bilhões de entradas. (Parte 2)



, PostgreSQL SSD HDD . .

Dr. Tariff (iOS, Android) .

PostgreSQL RAID-0 SSD . RAID mdadm. ( , ) – 512k.


iostat ( sysstat). ssd 95-100%. RAID 90%. htop. , , 30-50%. Python-, 20% . , .

Benchmark




, . .

PostgreSQL RAID


.




15% , . . iostat 90%, 100%. .




40% , . , , , 2 .

. 10


. – 10 . 423 212 . 14 .

10 .



20% 1 .



20-40%.

:

10 .


, . 64. Shared_buffers = 2048mb.



10 , . . . htop 100%. 20% Python-. , .

100 6-7 . shared_buffers , . .

1 10 . .

, . . , .


SSD RAID-0 , , . , .

MikeGav , SSD . SSD 85-90%. , 75%. SSD RAID-0 PostgreSQL.

Dr. Tariff Android iOS.


Facebook.

Source: https://habr.com/ru/post/pt383327/


All Articles