Achọpụtala mgbanwe na kernel Linux 7.0 nke na-ebelata arụmọrụ PostgreSQL site na ọkara.

Otu injinia Amazon chọpụtara mgbanwe kpọmkwem na Linux kernel 7.0, nke a na-atụ anya na a ga-ewepụta na Eprel 13. Mgbanwe na ntọala nhazi ọrụ butere mbelata dị ukwuu na mmepụta na nzaghachi mgbe a na-agba PostgreSQL na sistemụ ARM64. Site na iji kernel 7.0, arụmọrụ na nnwale "mmelite dị mfe" pgbench dara ihe fọrọ nke nta ka ọ bụrụ okpukpu abụọ, site na 98565 ruo 50751.

Ihe kpatara mbelata a bụ mgbanwe nke usoro nhazi oge site na PREEMPT_NONE gaa na PREEMPT_LAZY na usoro nhazi ndị na-akwado ya. Nke a mere ka PostgreSQL jiri 55% nke oge CPU ya kpọọ s_lock() n'ime oghere onye ọrụ. Iji dozie nsogbu a, a na-atụ aro ka eweghachi PREEMPT_NONE na ndabara wee wepụ ya na ntọala ARCH_NO_PREEMPT.

Peter Zijlstra, onye dere mgbanwe ndị kpatara mgbanwe ahụ na onye na-ahụ maka nhazi ọrụ na sistemụ kernel metụtara mkpọchi, kwuru na ọ dị mkpa ka e tinye ndozi na koodu PostgreSQL. Iji dozie mmebi arụmọrụ, ọ tụrụ aro ka e jiri ndọtị "rseq slice" (Restartable Sequences) agbakwunyere na kernel PostgreSQL iji belata ohere nke ịchụpụ onye njide mkpọchi.

Amabeghị mkpebi Linus Torvalds ga-eme, ebe ọ na-agbaso ụkpụrụ na kernel ekwesịghị imebi arụmọrụ ma ọ bụ mebie ndakọrịta oghere onye ọrụ. N'otu aka, kernel 7.0 nọ na usoro nnwale ikpeazụ tupu ewepụta ya, na ịtụgharị ntọala onye nhazi oge nwere ike ibute nlọghachi ndị ọzọ. N'aka nke ọzọ, ndị ọrụ nwere ike ịnweta ọkara nke arụmọrụ nke otu n'ime nchekwa data kachasị ewu ewu.

isi: opennet.ru

Tinye a comment