{"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\/et\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","title":{"rendered":"OrioleDB seitsmes beetaversioon, k\u00f5rge j\u00f5udlusega andmesalvestusmootor PostgreSQL-le","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Esitatud on OrioleDB beta7 salvestusmoonutuse beetaversioon ja avaldatud on uute testide tulemused, mis n\u00e4itavad m\u00e4rkimisv\u00e4\u00e4rset j\u00f5udluse paranemist v\u00f5rreldes traditsioonilise PostgreSQL-iga. Versioonis beta7 on rakendatud optimeerimisi, mis on suunatud mitme l\u00f5imekoormuse t\u00f6\u00f6tamise parandamisele ja lugemise ning kirjutamise operatsioonide kiirendamisele. OrioleDB esimene stabiilne v\u00e4ljalase on planeeritud 2025. aastaks. Mootor on kirjutatud C keeles ja levitatakse PostgreSQL litsentsi alusel, mis sarnaneb BSD ja MIT litsentsidega. <\/p>\n

OrioleDB projekt arendab PostgreSQL alternatiivset salvestusmoonutust, mis on v\u00e4lja t\u00f6\u00f6tatud standardse salvestusmoonutuse piirangute \u00fcletamiseks ja s\u00fcsteemi \u00fcldise efektiivsuse t\u00f5stmiseks. N\u00e4iteks v\u00f5imaldab OrioleDB v\u00e4ltida VACUUM operatsiooni perioodiliselt, et pr\u00fcgikogumist ilmselt t\u00e4nu MVCC (Multi-Version Concurrency Control) mehhanismi rakendamisele, mis p\u00f5hineb tagasih\u00fcgikogumitel (undo logs) ja mis t\u00f6\u00f6tab \u00fcksikute blokkide ja ridade tasandil, samuti automaatse lehtede \u00fchinemise s\u00fcsteemiga, mis sisaldab andmeid. OrioleDB kasutab ka 64-bitiseid tehingu identifikaatoreid, mis lahendab loendite \u00fclevoolu probleemi. <\/p>\n

OrioleDB-s on jagatud s\u00fcsteemide kasutamise lihtsustamiseks ja operatsioonide paralleelseks teostamiseks organiseeritud WAL-tehingute logi juhtimine ridade tasandil. UPDATE operatsiooni k\u00e4igus toetatakse andmete kohapealset asendamist (ilma praeguse kirje vabastamiseta ja uue loomisega), mis m\u00f5jutab positiivselt j\u00f5udlust. OrioleDB-s on rakendatud ka v\u00f5imalusi, nagu andmelehtede lugemine ilma lukustamiseta, lehtede otse sidumine m\u00e4llu lehtedega, mis on pidevas m\u00e4lus, CoW (copy-on-write) mehhanismi rakendamine kontrollpunktide fikseerimisel, et luua koosk\u00f5lalisi hooldusakseid igal ajal, ja andmete salvestamise re\u017eiim, mis kasutab ZSTD algoritmi kokku surumiseks. <\/p>\n

Seitsme OrioleDB beetaversiooni piirangutest v\u00f5ib v\u00e4lja tuua ainult B-puu formaadis indeksite kasutamise lubamise (k tulevikus toetatakse k\u00f5iki PostgerSQL indeksit\u00fc\u00fcpe) ning ettevalmistatud tehingute (PREPARE TRANSACTION) ja k\u00e4su «REINDEX» toetamata j\u00e4tmise koos «CONCURRENTLY» re\u017eiimiga. OrioleDB on rakendatud plugina, mis n\u00f5uab muudatusi PostgreSQLi p\u00f5hikoodeksis. <\/p>\n

Performance testides TPC-C, mis simuleerivad tehingute t\u00f6\u00f6tlemise koormust reaalses keskkonnas, n\u00e4itas seitsmes OrioleDB beeta-versioon tunduvalt paremaid tulemusi v\u00f5rreldes tavalise PostgreSQL mootoriga. Testid viidi l\u00e4bi erineva hulga samaaegsete klientidega, et hinnata s\u00fcsteemi skaleeritavust ja j\u00f5udlust koormuse suurenemisel. <\/p>\n

Tehingute l\u00e4bilaskev\u00f5imet hindavates testides saavutas OrioleDB mootor k\u00f5rgema l\u00e4bilaskev\u00f5ime, mida m\u00f5\u00f5deti tehingutes minutis (tpmC). Klientide arvu suurenedes j\u00e4tkas OrioleDB j\u00f5udlus lineaarset kasvu, samas kui PostgreSQL Heap mootoril ilmnes p\u00e4rast teatud piiri tendents stagnatsioonile ja isegi langusele.

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

Vastusaja testides oli OrioleDB tehingute keskmine vastusaeg m\u00e4rgatavalt madalam v\u00f5rreldes PostgreSQL-ga. Seega saavad OrioleDB-l baseeruvad s\u00fcsteemid samas ajavahemikus t\u00f6\u00f6delda rohkem tehinguid, tagades samal ajal kiirema p\u00e4ringute teenindamise. Ressursside kasutuse m\u00f5\u00f5tmisel n\u00e4itas OrioleDB mootor t\u00f5husamat CPU ja m\u00e4lu kasutamist, t\u00e4nu optimeeritud ressursihaldusele.
\n
Allikas: opennet.ru<\/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\udd47Seitsmes beeta versioon OrioleDB, k\u00f5rgj\u00f5udlusega salvestusmootor PostgreSQL jaoks | ProHoster","description":"Esitletud on OrioleDB beta7 salvestusmootori beetaversioon ja avalikustatud on uute testide tulemused, mis n\u00e4itavad m\u00e4rkimisv\u00e4\u00e4rset j\u00f5udluse paranemist v\u00f5rreldes traditsioonilise PostgreSQL-ga.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/120814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=120814"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/120814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/120815"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=120814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=120814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=120814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}