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

Esitatud on OrioleDB beta7 salvestusmootori beetaversioon ja avaldatud on uute testide tulemused, mis n\u00e4itavad m\u00e4rkimisv\u00e4\u00e4rset j\u00f5udluse paranemist traditsioonilise PostgreSQLiga v\u00f5rreldes. Beetaversioonis beta7 on tehtud optimeerimisi, mis aitavad parandada mitme l\u00f5ime koormuse t\u00f6\u00f6tlemist ja kiirendada lugemis- ja kirjutamistoiminguid. Esimene stabiilne OrioleDB v\u00e4ljaanne on plaanis 2025. aastaks. Mootor on kirjutatud C keeles ja levitatakse PostgreSQLi litsentsi all, mis sarnaneb BSD ja MIT litsentsidega. <\/p>\n

Projekt OrioleDB arendab PostgreSQLi alternatiivset salvestusmootorit, mis on loodud standardse salvestusmehhanismi piirangute \u00fcletamiseks ja s\u00fcsteemi \u00fcldise t\u00f5hususe suurendamiseks. N\u00e4iteks v\u00f5imaldab OrioleDB v\u00e4ltida perioodiliste VACUUM toimingute l\u00e4biviimist prahi kogumiseks, rakendades MVCC (Multi-Version Concurrency Control) mehhanismi, mis p\u00f5hineb tagasiv\u00f5tmise logidel (undo logs), mis t\u00f6\u00f6tavad individuaalsete plokkide ja ridade tasemel, samuti andmeid sisaldavate lehtede automaatse sulandamise s\u00fcsteemi. OrioleDB kasutab ka 64-bitiseid tehingu identifikaatoreid, mis lahendab loenduri \u00fclet\u00e4itumise probleemi. <\/p>\n

Jaotatud s\u00fcsteemide lihtsustamiseks ja OrioleDB-s toimingute paralleelseks tegemiseks on korraldatud WAL-tehingu logi pidamine ridade tasemel. UPDATE toimingu t\u00e4itmisel toetatakse andmete asendamist kohapeal (ilma praeguse kirje vabastamata ja uue loomata), mis m\u00f5jutab soodsalt j\u00f5udlust. OrioleDB-s on rakendatud v\u00f5imalusi, nagu andmelahtede lugemine ilma lukustamiseta, lehtede otsene sidumine m\u00e4lu lehtedega, mis asuvad p\u00fcsivas salvestuses, ning CoW (copy-on-write) mehhanismi rakendamine kontrollpunktide fikseerimisel, et luua mistahes ajahetkel j\u00e4rjepidevaid snapshot'e, samuti andmete salvestamise re\u017eiim kokku surutud kujul kasutades ZSTD algoritmi. <\/p>\n

Seitsmest OrioleDB beetaversioonist p\u00e4rit piirangutest on m\u00e4rgitud, et hetkel on toetatud vaid B-puu vormingus indekseid (tulevikus lisanduvad k\u00f5ik PostgreSQL indeksi t\u00fc\u00fcbid) ning puudub toetuste eelnevalt ettevalmistatud tehingud (PREPARE TRANSACTION) ja k\u00e4sk «REINDEX» re\u017eiimis «CONCURRENTLY». OrioleDB on teostatud plugina laadi laiendusena, mis n\u00f5uab muudatusi PostgreSQL peamises koodibaasis. <\/p>\n

Toimivuskatsetes TPC-C, mis simuleerivad tehingut\u00f6\u00f6tluse koormust reaalsetes tingimustes, n\u00e4itas seitsmes beetaversioon OrioleDB m\u00e4rkimisv\u00e4\u00e4rset \u00fclekaalu v\u00f5rreldes vaikimisi PostgreSQL mootori t\u00f6\u00f6ga. Testimine viidi l\u00e4bi erinevate samaaegselt t\u00f6\u00f6tavate klientide arvuga, et hinnata s\u00fcsteemi skaleeritavust ja j\u00f5udlust koormuse suurendamisel. <\/p>\n

Tehingute l\u00e4bilaskvuse hindamisel saavutas OrioleDB mootor k\u00f5rgema l\u00e4bilaskev\u00f5ime, m\u00f5\u00f5detuna tehingute minutis (tpmC). Kliendi arvu suurenedes suurenes OrioleDB j\u00f5udlus lineaarselt, samas kui Heap mootori PostgreSQL-is t\u00e4heldati tendentsi stagnatsiooni ja isegi v\u00e4henemise suunas p\u00e4rast teatud piiri.

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

Reaktsiooniaja katsetes oli OrioleDB tehingute keskmine reaktsiooniaeg m\u00e4rkimisv\u00e4\u00e4rselt madalam v\u00f5rreldes PostgreSQL-iga. Seega saavad OrioleDB p\u00f5hised s\u00fcsteemid t\u00f6\u00f6delda rohkem tehinguid sama aja jooksul, pakkudes samas kiiremat p\u00e4ringute teenindust. Ressursside kasutamise m\u00f5\u00f5tmisel n\u00e4itas OrioleDB mootor t\u00f5husamat CPU ja m\u00e4lu kasutust, t\u00e4nu optimeeritud ressursside haldamisele.
\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-novosti-interneta"],"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 beetaversioon OrioleDB, k\u00f5rge j\u00f5udlusega salvestusmootor PostgreSQL jaoks | ProHoster","description":"Esitatud on OrioleDB beta7 salvestusmootori beetaversioon ja avaldatud on uute testide tulemused, mis n\u00e4itavad m\u00e4rkimisv\u00e4\u00e4rset j\u00f5udluse paranemist traditsioonilise PostgreSQLiga v\u00f5rreldes. Beetaversioonis beta7 on tehtud optimeerimisi, mis aitavad parandada mitme l\u00f5ime koormuse t\u00f6\u00f6tlemist ja kiirendada lugemis- ja kirjutamistoiminguid. Esimene stabiilne OrioleDB v\u00e4ljaanne on plaanis 2025. aastaks. Mootor on kirjutatud C keeles ja levitatakse","canonical_url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/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. \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","og:url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/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"},"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}]}}