{"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\/hu\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","title":{"rendered":"A hetedik b\u00e9taverzi\u00f3ja az OrioleDB-nek, egy nagy teljes\u00edtm\u00e9ny\u0171 t\u00e1rol\u00f3motor a PostgreSQL-hez.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Bemutat\u00e1sra ker\u00fclt az OrioleDB beta7 t\u00e1rol\u00f3motor b\u00e9taverzi\u00f3ja, valamint k\u00f6zz\u00e9tett\u00e9k az \u00faj tesztek eredm\u00e9nyeit, amelyek jelent\u0151s teljes\u00edtm\u00e9nyn\u00f6veked\u00e9st mutatnak a hagyom\u00e1nyos PostgreSQL-hez k\u00e9pest. A beta7 verzi\u00f3ban olyan optimaliz\u00e1ci\u00f3k ker\u00fcltek bevezet\u00e9sre, amelyek a t\u00f6bb sz\u00e1lon fut\u00f3 terhel\u00e9sek kezel\u00e9s\u00e9t \u00e9s az olvas\u00e1si \u00e9s \u00edr\u00e1si m\u0171veletek felgyors\u00edt\u00e1s\u00e1t c\u00e9lozz\u00e1k. Az OrioleDB els\u0151 stabil kiad\u00e1s\u00e1t 2025-re tervezik. A motor C nyelven k\u00e9sz\u00fclt, \u00e9s a PostgreSQL licenc alatt terjesztik, amely hasonl\u00f3 a BSD \u00e9s MIT licencekhez. <\/p>\n

Az OrioleDB projekt egy alternat\u00edv t\u00e1rol\u00f3motort fejleszt a PostgreSQL sz\u00e1m\u00e1ra, amelynek c\u00e9lja a standard t\u00e1rol\u00e1si mechanizmus korl\u00e1toz\u00e1sainak lek\u00fczd\u00e9se \u00e9s a rendszer \u00e1ltal\u00e1nos hat\u00e9konys\u00e1g\u00e1nak n\u00f6vel\u00e9se. P\u00e9ld\u00e1ul az OrioleDB lehet\u0151v\u00e9 teszi a VACUUM m\u0171velet id\u0151szakos v\u00e9grehajt\u00e1s\u00e1nak elker\u00fcl\u00e9s\u00e9t a szem\u00e9tgy\u0171jt\u00e9shez, k\u00f6sz\u00f6nhet\u0151en a log-alap\u00fa MVCC (Multi-Version Concurrency Control) mechanizmus megval\u00f3s\u00edt\u00e1s\u00e1nak, amely egyes blokkok \u00e9s sorok szintj\u00e9n m\u0171k\u00f6dik, valamint az adatokkal rendelkez\u0151 oldalak automatikus egyes\u00edt\u00e9si rendszer\u00e9nek. Az OrioleDB 64 bites tranzakci\u00f3azonos\u00edt\u00f3kat is haszn\u00e1l, ami megoldja a sz\u00e1ml\u00e1l\u00f3k t\u00falcsordul\u00e1s\u00e1nak probl\u00e9m\u00e1j\u00e1t. <\/p>\n

A felhaszn\u00e1l\u00e1s egyszer\u0171s\u00edt\u00e9se \u00e9rdek\u00e9ben elosztott rendszerekben \u00e9s az OrioleDB m\u0171veleteinek p\u00e1rhuzamos\u00edt\u00e1sa \u00e9rdek\u00e9ben a WAL tranzakci\u00f3s napl\u00f3t sor szinten vezetik. Az UPDATE m\u0171velet v\u00e9grehajt\u00e1sakor a helysz\u00edni adatcsere t\u00e1mogatott (an\u00e9lk\u00fcl, hogy az aktu\u00e1lis rekordot felszabad\u00edtan\u00e1nk \u00e9s \u00faj rekordot hozn\u00e1nk l\u00e9tre), ami pozit\u00edvan hat a teljes\u00edtm\u00e9nyre. Az OrioleDB-ben olyan lehet\u0151s\u00e9gek is megval\u00f3s\u00edt\u00e1sra ker\u00fcltek, mint k\u00f6zvetlen oldalak \u00f6sszekapcsol\u00e1sa a mem\u00f3ri\u00e1ban l\u00e9v\u0151 oldalakkal \u00e9s a tart\u00f3s t\u00e1rol\u00f3ban, a CoW (copy-on-write) mechanizmus alkalmaz\u00e1sa a kontrollpontok r\u00f6gz\u00edt\u00e9si folyamat\u00e1ban az ellentmond\u00e1s-mentes pillanatk\u00e9pek l\u00e9trehoz\u00e1s\u00e1hoz b\u00e1rmikor, valamint a ZSTD algoritmussal t\u00f6rt\u00e9n\u0151 t\u00f6m\u00f6r\u00edtett adatkezel\u00e9s m\u00f3dja. <\/p>\n

A hetedik b\u00e9taverzi\u00f3ban az OrioleDB-nek van n\u00e9h\u00e1ny korl\u00e1toz\u00e1sa, amelyek k\u00f6z\u00e9 tartozik, hogy jelenleg csak B-fa form\u00e1tum\u00fa indexek haszn\u00e1lhat\u00f3k (a j\u00f6v\u0151ben minden PostgreSQL indext\u00edpus t\u00e1mogat\u00e1sa el\u00e9rhet\u0151 lesz), tov\u00e1bb\u00e1 a felk\u00e9sz\u00edtett tranzakci\u00f3k (PREPARE TRANSACTION) \u00e9s a «REINDEX» parancs hi\u00e1nya a «CONCURRENTLY» m\u00f3dban. Az OrioleDB plug-in kiterjeszt\u00e9sk\u00e9nt val\u00f3sult meg, amely m\u00f3dos\u00edt\u00e1sokat ig\u00e9nyel a PostgreSQL alap k\u00f3dalapj\u00e1ban. <\/p>\n

A TPC-C teljes\u00edtm\u00e9nytesztjeiben, amelyek val\u00f3s helyzetekben modellezik a tranzakci\u00f3s feldolgoz\u00e1s terhel\u00e9s\u00e9t, az OrioleDB hetedik b\u00e9taverzi\u00f3ja jelent\u0151s f\u00f6l\u00e9nyt mutatott a szok\u00e1sos PostgreSQL motorn\u00e1l. A tesztel\u00e9s k\u00fcl\u00f6nb\u00f6z\u0151 egym\u00e1ssal p\u00e1rhuzamosan dolgoz\u00f3 kliens mennyis\u00e9gekkel zajlott, hogy felm\u00e9rje a rendszer sk\u00e1l\u00e1zhat\u00f3s\u00e1g\u00e1t \u00e9s teljes\u00edtm\u00e9ny\u00e9t terhel\u00e9s n\u00f6veked\u00e9se eset\u00e9n. <\/p>\n

A tranzakci\u00f3s \u00e1tereszt\u0151k\u00e9pess\u00e9get \u00e9rt\u00e9kel\u0151 tesztek sor\u00e1n az OrioleDB motor magasabb \u00e1tereszt\u0151k\u00e9pess\u00e9get \u00e9rt el, amit tranzakci\u00f3k percenk\u00e9nti sz\u00e1m\u00e1val (tpmC) m\u00e9rtek. A klienssz\u00e1m n\u00f6veked\u00e9s\u00e9vel az OrioleDB teljes\u00edtm\u00e9nye tov\u00e1bbra is line\u00e1risan n\u0151tt, m\u00edg a PostgreSQL Heap motorj\u00e1nak teljes\u00edtm\u00e9nye egy bizonyos k\u00fcsz\u00f6b ut\u00e1n stagn\u00e1lni vagy ak\u00e1r cs\u00f6kkenni kezdett.

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

A v\u00e1laszid\u0151 tesztek sor\u00e1n az OrioleDB tranzakci\u00f3inak \u00e1tlagos v\u00e1laszideje jelent\u0151sen alacsonyabb volt a PostgreSQL-hez k\u00e9pest. \u00cdgy az OrioleDB alap\u00fa rendszerek t\u00f6bb tranzakci\u00f3t tudnak kezelni ugyanannyi id\u0151 alatt, mik\u00f6zben gyorsabb lek\u00e9rdez\u00e9s-kiszolg\u00e1l\u00e1st biztos\u00edtanak. Az er\u0151forr\u00e1sok haszn\u00e1lat\u00e1nak m\u00e9r\u00e9sekor az OrioleDB motor hat\u00e9konyabb CPU- \u00e9s mem\u00f3riahaszn\u00e1latot mutatott, k\u00f6sz\u00f6nhet\u0151en az optimaliz\u00e1lt er\u0151forr\u00e1skezel\u00e9snek.
\n
Forr\u00e1s: 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\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\udd47A hetedik b\u00e9taverzi\u00f3 OrioleDB, a PostgreSQL sz\u00e1m\u00e1ra k\u00e9sz\u00fclt nagy teljes\u00edtm\u00e9ny\u0171 t\u00e1rol\u00f3motor | ProHoster","description":"Bemutat\u00e1sra ker\u00fclt az OrioleDB beta7 t\u00e1rol\u00f3motor b\u00e9taverzi\u00f3ja, \u00e9s k\u00f6zz\u00e9tett\u00e9k az \u00faj tesztek eredm\u00e9nyeit, melyek jelent\u0151s teljes\u00edtm\u00e9nyn\u00f6veked\u00e9st mutattak a hagyom\u00e1nyos PostgreSQL-hez k\u00e9pest.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/120814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=120814"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/120814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/120815"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=120814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=120814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=120814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}