{"id":120814,"date":"2024-12-02T09:45:59","date_gmt":"2024-12-02T07:46:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql"},"modified":"2024-12-02T09:45:59","modified_gmt":"2024-12-02T07:46:01","slug":"sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","title":{"rendered":"Cea de-a \u0219aptea versiune beta OrioleDB, un motor de stocare de \u00eenalt\u0103 performan\u021b\u0103 pentru PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A fost lansat\u0103 versiunea beta a motorului de stocare OrioleDB beta7 \u0219i au fost publicate rezultatele noilor teste, care demonstreaz\u0103 o cre\u0219tere semnificativ\u0103 a performan\u021bei comparativ cu PostgreSQL tradi\u021bional. \u00cen versiunea beta7 au fost implementate optimiz\u0103ri menite s\u0103 \u00eembun\u0103t\u0103\u021beasc\u0103 performan\u021ba cu sarcini de lucru multithreading \u0219i s\u0103 accelereze opera\u021biunile de citire \u0219i scriere. Prima versiune stabil\u0103 a OrioleDB este planificat\u0103 pentru lansare \u00een 2025. Motorul este scris \u00een limbajul C \u0219i este distribuit sub licen\u021ba PostgreSQL, similar cu licen\u021bele BSD \u0219i MIT. <\/p>\n

Proiectul OrioleDB dezvolt\u0103 un motor de stocare alternativ pentru PostgreSQL, creat \u00een scopul dep\u0103\u0219irii limit\u0103rilor mecanismului standard de stocare \u0219i cre\u0219terii eficien\u021bei generale a sistemului. De exemplu, OrioleDB permite evitarea execu\u021biei periodice a opera\u021biunii VACUUM pentru colectarea gunoiului, datorit\u0103 implement\u0103rii mecanismului MVCC (Control al Concuren\u021bei pe Versiuni Multiple) pe baza jurnalelor de anulare (undo logs), care opereaz\u0103 la nivelul blocurilor \u0219i r\u00e2ndurilor individuale, precum \u0219i a sistemului automat de fuziune a paginilor care con\u021bin date. OrioleDB utilizeaz\u0103, de asemenea, identificatori de tranzac\u021bii pe 64 de bi\u021bi, ceea ce rezolv\u0103 problema dep\u0103\u0219irii contoarelor. <\/p>\n

Pentru a simplifica utilizarea \u00een sisteme distribuite \u0219i pentru a paraleliza opera\u021biunile \u00een OrioleDB, s-a organizat vedenie a jurnalului WAL de tranzac\u021bii la nivelul r\u00e2ndurilor. \u00cen timpul execut\u0103rii opera\u021biunii UPDATE, este sus\u021binut\u0103 \u00eenlocuirea datelor la loc (f\u0103r\u0103 a elibera \u00eenregistrarea curent\u0103 \u0219i a crea una nou\u0103), ceea ce are un impact pozitiv asupra performan\u021bei. \u00cen OrioleDB sunt implementate, de asemenea, func\u021bionalit\u0103\u021bi cum ar fi citirea paginilor cu date f\u0103r\u0103 utilizarea blocajelor, legarea direct\u0103 a paginilor din memorie cu paginile din stocarea permanent\u0103, aplicarea mecanismului CoW (copy-on-write) la fixarea punctelor de control pentru a crea instantanee consistente \u00een orice moment, \u0219i modul de stocare a datelor \u00een format comprimat folosind algoritmul ZSTD. <\/p>\n

\u00cen prezent, \u00een beta 7 a OrioleDB, se remarc\u0103 limitarea utiliz\u0103rii doar a indicilor \u00een format B-tree (\u00een viitor, va fi ad\u0103ugat\u0103 suport pentru toate tipurile de indici PostgreSQL), precum \u0219i lipsa suportului pentru tranzac\u021bii preg\u0103tite (PREPARE TRANSACTION) \u0219i comanda \u201eREINDEX\u201d \u00een modul \u201eCONCURRENTLY\u201d. OrioleDB este implementat sub forma unei extensii plug-in, necesit\u00e2nd modific\u0103ri \u00een baza de cod principal\u0103 PostgreSQL. <\/p>\n

\u00cen teste de performan\u021b\u0103 TPC-C, care simuleaz\u0103 o \u00eenc\u0103rcare de procesare tranzac\u021bional\u0103 \u00een condi\u021bii reale, cea de-a \u0219aptea versiune beta OrioleDB a demonstrat un avantaj semnificativ fa\u021b\u0103 de motorul standard PostgreSQL. Testarea a fost realizat\u0103 cu un num\u0103r variat de clien\u021bi activi simultan, pentru a evalua scalabilitatea \u0219i performan\u021ba sistemului sub o \u00eenc\u0103rcare crescut\u0103. <\/p>\n

\u00cen testele care evalueaz\u0103 l\u0103\u021bimea de band\u0103 a tranzac\u021biilor, motorul OrioleDB a atins o l\u0103\u021bime de band\u0103 mai mare, m\u0103surat\u0103 \u00een tranzac\u021bii pe minut (tpmC). Pe m\u0103sur\u0103 ce num\u0103rul de clien\u021bi a crescut, performan\u021ba OrioleDB a continuat s\u0103 creasc\u0103 liniar, \u00een timp ce motorul Heap din PostgreSQL a ar\u0103tat o tendin\u021b\u0103 de stagnare \u0219i chiar o sc\u0103dere dup\u0103 un anumit prag.

\"Cea<\/center>
\"Cea<\/center>
\"Cea<\/center> <\/p>\n

\u00cen testele de timp de r\u0103spuns, timpul mediu de r\u0103spuns al tranzac\u021biilor \u00een OrioleDB a fost semnificativ mai mic comparativ cu PostgreSQL. Astfel, sistemele bazate pe OrioleDB pot procesa mai multe tranzac\u021bii \u00een aceea\u0219i perioad\u0103, oferind \u00een acela\u0219i timp un serviciu mai rapid la cereri. C\u00e2nd s-a m\u0103surat utilizarea resurselor, motorul OrioleDB a demonstrat o utilizare mai eficient\u0103 a CPU-ului \u0219i memoriei, datorit\u0103 gestion\u0103rii optimizate a resurselor.
\n
Sursa: opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u0431\u0435\u0442\u0430-\u0432\u0435\u0440\u0441\u0438\u044f \u0434\u0432\u0438\u0436\u043a\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f OrioleDB beta7 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u044b \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u043d\u043e\u0432\u044b\u0445 \u0442\u0435\u0441\u0442\u043e\u0432, \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0438\u0440\u0443\u044e\u0449\u0438\u0445 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0435 \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u043c PostgreSQL. \u0412 \u0432\u0435\u0440\u0441\u0438\u0438 beta7 \u0431\u044b\u043b\u0438 \u0432\u043d\u0435\u0434\u0440\u0435\u043d\u044b \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438, \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u0430 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u043c\u043d\u043e\u0433\u043e\u043f\u043e\u0442\u043e\u0447\u043d\u044b\u043c\u0438 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430\u043c\u0438 \u0438 \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u0447\u0442\u0435\u043d\u0438\u044f \u0438 \u0437\u0430\u043f\u0438\u0441\u0438. \u041f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 OrioleDB \u043f\u043b\u0430\u043d\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0432 2025 \u0433\u043e\u0434\u0443. \u0414\u0432\u0438\u0436\u043e\u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 \u0421\u0438 \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":120815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-120814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Cea de-a \u0219aptea versiune beta OrioleDB, motorul de stocare de \u00eenalt\u0103 performan\u021b\u0103 pentru PostgreSQL | ProHoster","description":"A fost lansat\u0103 versiunea beta a motorului de stocare OrioleDB beta7, iar rezultatele noilor teste arat\u0103 o cre\u0219tere semnificativ\u0103 a performan\u021bei \u00een compara\u021bie cu PostgreSQL tradi\u021bional.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0421\u0435\u0434\u044c\u043c\u0430\u044f \u0431\u0435\u0442\u0430 \u0432\u0435\u0440\u0441\u0438\u044f OrioleDB, \u0432\u044b\u0441\u043e\u043a\u043e\u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u0434\u0432\u0438\u0436\u043a\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u043b\u044f PostgreSQL | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u0431\u0435\u0442\u0430-\u0432\u0435\u0440\u0441\u0438\u044f \u0434\u0432\u0438\u0436\u043a\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f OrioleDB beta7 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u044b \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u043d\u043e\u0432\u044b\u0445 \u0442\u0435\u0441\u0442\u043e\u0432, \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0438\u0440\u0443\u044e\u0449\u0438\u0445 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0435 \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u043c PostgreSQL.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2024-12-02T07:46:01+00:00","article:modified_time":"2024-12-02T07:46:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"120814","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-23 08:30:22","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 08:30:22","updated":"2026-01-23 08:30:22","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/120814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=120814"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/120814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/120815"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=120814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=120814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=120814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}